Skip to content

Instantly share code, notes, and snippets.

View Tesla9527's full-sized avatar

Tesla Lau Tesla9527

17 followers · 38 following
View GitHub Profile
@Tesla9527
Tesla9527 / c# - LINQ 8
Created September 16, 2015 09:28
using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
namespace ConsoleApplication1
{
class Customer
@Tesla9527
Tesla9527 / Controllers in an mvc application
Last active November 21, 2015 14:03
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace WebApplication1.Controllers
{
public class HomeController : Controller
{
@Tesla9527
Tesla9527 / Views in an mvc application
Last active November 21, 2015 15:11
-----------------------------
Below is code in HomeController.cs
-----------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace WebApplication1.Controllers
@Tesla9527
Tesla9527 / Models in an mvc application
Created November 22, 2015 10:16
-----------------------------
Below is code in Employee.cs
-----------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace WebApplication2.Models
{
@Tesla9527
Tesla9527 / Data access in mvc using entity framework
Created November 22, 2015 11:15
-----------------------------
Below is code in EmployeeContext.cs
-----------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Entity;
namespace WebApplication2.Models
@Tesla9527
Tesla9527 / Generate hyperlinks using actionlink html helper
Created November 22, 2015 12:08
@Tesla9527
Tesla9527 / Working with multiple tables in mvc
Created November 23, 2015 11:35
-----------------------------
Below is code in EmployeeController.cs
-----------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using WebApplication2.Models;
@Tesla9527
Tesla9527 / sql 拼接字段
Created December 18, 2015 07:45
SELECT a.GroupCD,a.GroupName,a.GroupParentCD,
( SELECT GroupName
FROM dbo.Bpm_OrganizationMiddle
WHERE GroupCD = a.GroupParentCD
) GroupParentCDName,a.is_delete
FROM dbo.Bpm_OrganizationMiddle AS a;
@Tesla9527
Tesla9527 / Replace connectionString using PowerShell
Created January 26, 2016 06:45
$connectionString = "Data Source=shaappt0001;Initial Catalog=Bpm;Persist Security Info=true;User ID=sa;PWD=Passw0rd;Packet Size=4096;" providerName="System.Data.SqlClient"
$webConfigPath = "%teamcity.build.workingDir%\Bpm\web.config"
$xml = [xml](get-content $webConfigPath)
$root = $xml.get_DocumentElement();
$root.connectionStrings.add.connectionString = $connectionString
$xml.Save($webConfigPath)
@Tesla9527
Tesla9527 / 使用PowerShell重命名文件
Created March 2, 2016 02:20
rename-item -path aaa.apk -newname bbb.apk