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);
}
