public void Update(OtherShiyaInfo entity) { using (var conn = new SqlConnection(connectString)) { string sql = @"UPDATE OtherShiya SET saleid=@saleid,shuigongid=@shuigongid,shiyaid=@shiyaid,customerid=@customerid,orderId=@orderId,truename=@truename,mobile=@mobile,address=@address,anname=@anname,anmobile=@anmobile,housetype=@housetype,kaifashang=@kaifashang,jiazhuang=@jiazhuang,kongtiao=@kongtiao,guanjian=@guanjian,pushe=@pushe,baohu=@baohu,beizhu=@beizhu,zongfa=@zongfa,hunzhuang=@hunzhuang,huaheng=@huaheng,xiangqian=@xiangqian,guolvqi=@guolvqi,jietou=@jietou,baoyastart=@baoyastart,baoyaend=@baoyaend,yunxing=@yunxing,jiance=@jiance,shiyaname=@shiyaname,shiyamobile=@shiyamobile,gaozhi=@gaozhi,stat=@stat, addtime = @addtime where id=@id"; conn.Execute(sql, entity); } }
public int Add(OtherShiyaInfo entity) { using (var conn = new SqlConnection(connectString)) { string sql = @"INSERT INTO OtherShiya(saleid,shuigongid,shiyaid,customerid,orderId,truename,mobile,address,anname,anmobile,housetype,kaifashang,jiazhuang,kongtiao,guanjian,pushe,baohu,beizhu,zongfa,hunzhuang,huaheng,xiangqian,guolvqi,jietou,baoyastart,baoyaend,yunxing,jiance,shiyaname,shiyamobile,gaozhi,stat,addtime) VALUES(@saleid,@shuigongid,@shiyaid,@customerid,@orderId,@truename,@mobile,@address,@anname,@anmobile,@housetype,@kaifashang,@jiazhuang,@kongtiao,@guanjian,@pushe,@baohu,@beizhu,@zongfa,@hunzhuang,@huaheng,@xiangqian,@guolvqi,@jietou,@baoyastart,@baoyaend,@yunxing,@jiance,@shiyaname,@shiyamobile,@gaozhi,@stat,@addtime); select SCOPE_IDENTITY()"; return(conn.Query <int>(sql, entity).Single()); } }
public static void Update(OtherShiyaInfo entity) { dal.Update(entity); }
public static int Add(OtherShiyaInfo entity) { return(dal.Add(entity)); }