public void EditCar(Model.PO.CarPO car) { _daoCar.Update(car); }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "Customer"; * parameters[1].Value = "CustomerID"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod #endregion ExtensionMethod public int AddAll(Model.PO.CustomerPO cust, Model.PO.CarPO car) { int result; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Customer("); strSql.Append("Name,MobileNO,Sex,Birthday,ICNo,Weixin,Company,CardFlag,LogicalStatus,CreatorID,CreatedDate,LastModifierID,LastModifiedDate)"); strSql.Append(" values ("); strSql.Append("@Name,@MobileNO,@Sex,@Birthday,@ICNo,@Weixin,@Company,@CardFlag,@LogicalStatus,@CreatorID,@CreatedDate,@LastModifierID,@LastModifiedDate)"); strSql.Append("select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@MobileNO", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.NVarChar, 50), new SqlParameter("@Birthday", SqlDbType.NVarChar, 50), new SqlParameter("@ICNo", SqlDbType.NVarChar, 50), new SqlParameter("@Weixin", SqlDbType.NVarChar, 50), new SqlParameter("@Company", SqlDbType.NVarChar, 50), new SqlParameter("@CardFlag", SqlDbType.Int, 4), new SqlParameter("@LogicalStatus", SqlDbType.Int, 4), new SqlParameter("@CreatorID", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@LastModifierID", SqlDbType.NVarChar, 50), new SqlParameter("@LastModifiedDate", SqlDbType.DateTime) }; parameters[0].Value = cust.Name; parameters[1].Value = cust.MobileNO; parameters[2].Value = cust.Sex; parameters[3].Value = cust.Birthday; parameters[4].Value = cust.ICNo; parameters[5].Value = cust.Weixin; parameters[6].Value = cust.Company; parameters[7].Value = cust.CardFlag; parameters[8].Value = cust.LogicalStatus; parameters[9].Value = cust.CreatorID; parameters[10].Value = cust.CreatedDate; parameters[11].Value = cust.LastModifierID; parameters[12].Value = cust.LastModifiedDate; StringBuilder strSqlcar = new StringBuilder(); strSqlcar.Append("insert into Car("); strSqlcar.Append("CarNo,Brand,CarModel,Capacity,Color,FrameNo,EngineNo,MaintainKM,InsureDate,ASDate,CustomerID,LogicalStatus,CreatorID,CreatedDate,LastModifierID,LastModifiedDate)"); strSqlcar.Append(" values ("); strSqlcar.Append("@CarNo,@Brand,@CarModel,@Capacity,@Color,@FrameNo,@EngineNo,@MaintainKM,@InsureDate,@ASDate,@carcuid,@LogicalStatus,@CreatorID,@CreatedDate,@LastModifierID,@LastModifiedDate)"); strSqlcar.Append("select @@IDENTITY"); SqlParameter[] parameterscar = { new SqlParameter("@CarNo", SqlDbType.NVarChar, 50), new SqlParameter("@Brand", SqlDbType.NVarChar, 50), new SqlParameter("@CarModel", SqlDbType.NVarChar, 50), new SqlParameter("@Capacity", SqlDbType.NVarChar, 50), new SqlParameter("@Color", SqlDbType.NVarChar, 50), new SqlParameter("@FrameNo", SqlDbType.NVarChar, 50), new SqlParameter("@EngineNo", SqlDbType.NVarChar, 50), new SqlParameter("@MaintainKM", SqlDbType.NVarChar, 50), new SqlParameter("@InsureDate", SqlDbType.DateTime), new SqlParameter("@ASDate", SqlDbType.DateTime), new SqlParameter("@carcuid", SqlDbType.Int, 4), new SqlParameter("@LogicalStatus", SqlDbType.Int, 4), new SqlParameter("@CreatorID", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@LastModifierID", SqlDbType.NVarChar, 50), new SqlParameter("@LastModifiedDate", SqlDbType.DateTime) }; parameterscar[0].Value = car.CarNo; parameterscar[1].Value = car.Brand; parameterscar[2].Value = car.CarModel; parameterscar[3].Value = car.Capacity; parameterscar[4].Value = car.Color; parameterscar[5].Value = car.FrameNo; parameterscar[6].Value = car.EngineNo; parameterscar[7].Value = car.MaintainKM; parameterscar[8].Value = car.InsureDate; parameterscar[9].Value = car.ASDate; parameterscar[10].Value = -1; parameterscar[11].Value = car.LogicalStatus; parameterscar[12].Value = car.CreatorID; parameterscar[13].Value = car.CreatedDate; parameterscar[14].Value = car.LastModifierID; parameterscar[15].Value = car.LastModifiedDate; Dictionary <string, object> dicsqls = new Dictionary <string, object>(); dicsqls.Add(strSql.ToString(), parameters); dicsqls.Add(strSqlcar.ToString(), parameterscar); try { DbHelperSQL.ExecutesqltranWithIndentity(dicsqls); result = 1; } catch (Exception ex) { throw ex; result = 0; } return(result); }
public void AddCar(Model.PO.CarPO car) { _daoCar.Add(car); }