public void UpdateData(ShippingDetailModel model) { List <string> sqls = new List <string>(); List <SqlParameter[]> cmdParms = new List <SqlParameter[]>(); StringBuilder str = new StringBuilder(); str.AppendLine("update Shipping set"); str.AppendLine(" State =@State"); str.AppendLine(" ,ShippingRate =@ShippingRate"); str.AppendLine(" ,IsDelete =@IsDelete"); str.AppendLine(" ,UpdateUser =@UpdateUser"); str.AppendLine(" ,UpdateTime =getdate()"); str.AppendLine(" where ShippingID=@ShippingID"); SqlParameter[] paras = new SqlParameter[6]; paras[0] = new SqlParameter("@State", Common.VariableConvert.ConvertStringToDBValue(model.State)); paras[1] = new SqlParameter("@ShippingRate", model.ShippingRate); paras[2] = new SqlParameter("@IsDelete", Common.VariableConvert.BitConverter(model.IsDelete)); paras[3] = new SqlParameter("@CreateUser", Common.VariableConvert.ConvertStringToDBValue(model.CreateUser)); paras[4] = new SqlParameter("@UpdateUser", Common.VariableConvert.ConvertStringToDBValue(model.UpdateUser)); paras[5] = new SqlParameter("@ShippingID", model.ShippingID); sqls.Add(str.ToString()); cmdParms.Add(paras); SqlAccess mySqlAccess = new SqlAccess(); mySqlAccess.ExecuteNonQuerys(sqls, cmdParms); }
public void InsertData(ShippingDetailModel model) { List <string> sqls = new List <string>(); List <SqlParameter[]> cmdParms = new List <SqlParameter[]>(); StringBuilder str = new StringBuilder(); str.AppendLine("Insert into Shipping"); str.AppendLine(" (State, ShippingRate, IsDelete, CreateTime, CreateUser, UpdateTime, UpdateUser) "); str.AppendLine(" Values (@State, @ShippingRate, @IsDelete, getdate(), @CreateUser,getdate(), @UpdateUser);"); SqlParameter[] paras = new SqlParameter[5]; paras[0] = new SqlParameter("@State", Common.VariableConvert.ConvertStringToDBValue(model.State)); paras[1] = new SqlParameter("@ShippingRate", model.ShippingRate); paras[2] = new SqlParameter("@IsDelete", Common.VariableConvert.BitConverter(model.IsDelete)); paras[3] = new SqlParameter("@CreateUser", Common.VariableConvert.ConvertStringToDBValue(model.CreateUser)); paras[4] = new SqlParameter("@UpdateUser", Common.VariableConvert.ConvertStringToDBValue(model.UpdateUser)); sqls.Add(str.ToString()); cmdParms.Add(paras); SqlAccess mySqlAccess = new SqlAccess(); mySqlAccess.ExecuteNonQuerys(sqls, cmdParms); }
public ShippingDetailModel GetDataByID(string id) { StringBuilder sql = new StringBuilder(); sql.AppendLine("SELECT "); sql.AppendLine(" ShippingID, State, ShippingRate, IsDelete"); sql.AppendLine(" FROM Shipping WITH(NOLOCK)"); sql.AppendLine(" WHERE ShippingID=@ShippingID"); SqlParameter[] paras = new SqlParameter[1]; paras[0] = new SqlParameter("@ShippingID", id); SqlAccess mySqlAccess = new SqlAccess(); DataSet ds = mySqlAccess.ExecuteAdapter(sql.ToString(), paras); ShippingDetailModel Shipping = new ShippingDetailModel(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { Shipping = DataMappingHelper <ShippingDetailModel> .DataTableToEntity(ds.Tables[0]); } return(Shipping); }