/// <summary>
/// 增加一条数据
/// </summary>
public int Add(PCMLib.Model.LogOperation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbl_LogOperation(");
strSql.Append("Type,TypeId,Message,AddDate,UserId,Detail)");
strSql.Append(" values (");
strSql.Append("@Type,@TypeId,@Message,@AddDate,@UserId,@Detail)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Type", SqlDbType.VarChar,50),
new SqlParameter("@TypeId", SqlDbType.Decimal,9),
new SqlParameter("@Message", SqlDbType.NVarChar,2000),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@UserId", SqlDbType.Decimal,9),
new SqlParameter("@Detail", SqlDbType.NVarChar,2000)};
parameters[0].Value = model.Type;
parameters[1].Value = model.TypeId;
parameters[2].Value = model.Message;
parameters[3].Value = model.AddDate;
parameters[4].Value = model.UserId;
parameters[5].Value = model.Detail;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(PCMLib.Model.MaterialDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbl_MaterialDetail(");
strSql.Append("Md_PcID,Md_Name,Md_Brand,Md_Size,Md_Price,Md_Count,Md_Total,Md_Seller,Md_Contact,Md_ContactTel,Md_Date,Md_State,Md_Remark,Md_Inputer,Md_InputDate,Md_Editer,Md_EditDate)");
strSql.Append(" values (");
strSql.Append("@Md_PcID,@Md_Name,@Md_Brand,@Md_Size,@Md_Price,@Md_Count,@Md_Total,@Md_Seller,@Md_Contact,@Md_ContactTel,@Md_Date,@Md_State,@Md_Remark,@Md_Inputer,@Md_InputDate,@Md_Editer,@Md_EditDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Md_PcID", SqlDbType.Decimal,9),
new SqlParameter("@Md_Name", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Brand", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Size", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Price", SqlDbType.Decimal,9),
new SqlParameter("@Md_Count", SqlDbType.Int,4),
new SqlParameter("@Md_Total", SqlDbType.Decimal,9),
new SqlParameter("@Md_Seller", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Contact", SqlDbType.NVarChar,50),
new SqlParameter("@Md_ContactTel", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Date", SqlDbType.DateTime),
new SqlParameter("@Md_State", SqlDbType.Int,4),
new SqlParameter("@Md_Remark", SqlDbType.NVarChar,500),
new SqlParameter("@Md_Inputer", SqlDbType.Decimal,9),
new SqlParameter("@Md_InputDate", SqlDbType.DateTime),
new SqlParameter("@Md_Editer", SqlDbType.Decimal,9),
new SqlParameter("@Md_EditDate", SqlDbType.DateTime)};
parameters[0].Value = model.Md_PcID;
parameters[1].Value = model.Md_Name;
parameters[2].Value = model.Md_Brand;
parameters[3].Value = model.Md_Size;
parameters[4].Value = model.Md_Price;
parameters[5].Value = model.Md_Count;
parameters[6].Value = model.Md_Total;
parameters[7].Value = model.Md_Seller;
parameters[8].Value = model.Md_Contact;
parameters[9].Value = model.Md_ContactTel;
parameters[10].Value = model.Md_Date;
parameters[11].Value = model.Md_State;
parameters[12].Value = model.Md_Remark;
parameters[13].Value = model.Md_Inputer;
parameters[14].Value = model.Md_InputDate;
parameters[15].Value = model.Md_Editer;
parameters[16].Value = model.Md_EditDate;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToDecimal(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(PCMLib.Model.Balance model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbl_Balance(");
strSql.Append("Bl_CtID,Bl_CompleteRate,Bl_CompleteDate,Bl_CompleteContent,Bl_ChangeType,Bl_ChangeContent,Bl_File,Bl_Remark,Bl_State,Bl_Inputer,Bl_InputDate,Bl_Editer,Bl_EditDate)");
strSql.Append(" values (");
strSql.Append("@Bl_CtID,@Bl_CompleteRate,@Bl_CompleteDate,@Bl_CompleteContent,@Bl_ChangeType,@Bl_ChangeContent,@Bl_File,@Bl_Remark,@Bl_State,@Bl_Inputer,@Bl_InputDate,@Bl_Editer,@Bl_EditDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Bl_CtID", SqlDbType.Decimal,9),
new SqlParameter("@Bl_CompleteRate", SqlDbType.Decimal,9),
new SqlParameter("@Bl_CompleteDate", SqlDbType.DateTime),
new SqlParameter("@Bl_CompleteContent", SqlDbType.NVarChar,500),
new SqlParameter("@Bl_ChangeType", SqlDbType.Int,4),
new SqlParameter("@Bl_ChangeContent", SqlDbType.NVarChar,500),
new SqlParameter("@Bl_File", SqlDbType.NVarChar,50),
new SqlParameter("@Bl_Remark", SqlDbType.NVarChar,500),
new SqlParameter("@Bl_State", SqlDbType.Int,4),
new SqlParameter("@Bl_Inputer", SqlDbType.Decimal,9),
new SqlParameter("@Bl_InputDate", SqlDbType.DateTime),
new SqlParameter("@Bl_Editer", SqlDbType.Decimal,9),
new SqlParameter("@Bl_EditDate", SqlDbType.DateTime)};
parameters[0].Value = model.Bl_CtID;
parameters[1].Value = model.Bl_CompleteRate;
parameters[2].Value = model.Bl_CompleteDate;
parameters[3].Value = model.Bl_CompleteContent;
parameters[4].Value = model.Bl_ChangeType;
parameters[5].Value = model.Bl_ChangeContent;
parameters[6].Value = model.Bl_File;
parameters[7].Value = model.Bl_Remark;
parameters[8].Value = model.Bl_State;
parameters[9].Value = model.Bl_Inputer;
parameters[10].Value = model.Bl_InputDate;
parameters[11].Value = model.Bl_Editer;
parameters[12].Value = model.Bl_EditDate;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToDecimal(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.Balance model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbl_Balance set ");
strSql.Append("Bl_CtID=@Bl_CtID,");
strSql.Append("Bl_CompleteRate=@Bl_CompleteRate,");
strSql.Append("Bl_CompleteDate=@Bl_CompleteDate,");
strSql.Append("Bl_CompleteContent=@Bl_CompleteContent,");
strSql.Append("Bl_ChangeType=@Bl_ChangeType,");
strSql.Append("Bl_ChangeContent=@Bl_ChangeContent,");
strSql.Append("Bl_File=@Bl_File,");
strSql.Append("Bl_Remark=@Bl_Remark,");
strSql.Append("Bl_State=@Bl_State,");
strSql.Append("Bl_Inputer=@Bl_Inputer,");
strSql.Append("Bl_InputDate=@Bl_InputDate,");
strSql.Append("Bl_Editer=@Bl_Editer,");
strSql.Append("Bl_EditDate=@Bl_EditDate");
strSql.Append(" where Bl_ID=@Bl_ID");
SqlParameter[] parameters = {
new SqlParameter("@Bl_CtID", SqlDbType.Decimal,9),
new SqlParameter("@Bl_CompleteRate", SqlDbType.Decimal,9),
new SqlParameter("@Bl_CompleteDate", SqlDbType.DateTime),
new SqlParameter("@Bl_CompleteContent", SqlDbType.NVarChar,500),
new SqlParameter("@Bl_ChangeType", SqlDbType.Int,4),
new SqlParameter("@Bl_ChangeContent", SqlDbType.NVarChar,500),
new SqlParameter("@Bl_File", SqlDbType.NVarChar,50),
new SqlParameter("@Bl_Remark", SqlDbType.NVarChar,500),
new SqlParameter("@Bl_State", SqlDbType.Int,4),
new SqlParameter("@Bl_Inputer", SqlDbType.Decimal,9),
new SqlParameter("@Bl_InputDate", SqlDbType.DateTime),
new SqlParameter("@Bl_Editer", SqlDbType.Decimal,9),
new SqlParameter("@Bl_EditDate", SqlDbType.DateTime),
new SqlParameter("@Bl_ID", SqlDbType.Decimal,9)};
parameters[0].Value = model.Bl_CtID;
parameters[1].Value = model.Bl_CompleteRate;
parameters[2].Value = model.Bl_CompleteDate;
parameters[3].Value = model.Bl_CompleteContent;
parameters[4].Value = model.Bl_ChangeType;
parameters[5].Value = model.Bl_ChangeContent;
parameters[6].Value = model.Bl_File;
parameters[7].Value = model.Bl_Remark;
parameters[8].Value = model.Bl_State;
parameters[9].Value = model.Bl_Inputer;
parameters[10].Value = model.Bl_InputDate;
parameters[11].Value = model.Bl_Editer;
parameters[12].Value = model.Bl_EditDate;
parameters[13].Value = model.Bl_ID;
int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(PCMLib.Model.Construction model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.Construction model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(PCMLib.Model.Completion model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.LogOperation model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.Purchase model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(PCMLib.Model.Balance model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.Balance model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.LogOperation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbl_LogOperation set ");
strSql.Append("Type=@Type,");
strSql.Append("TypeId=@TypeId,");
strSql.Append("Message=@Message,");
strSql.Append("AddDate=@AddDate,");
strSql.Append("UserId=@UserId,");
strSql.Append("Detail=@Detail");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Type", SqlDbType.VarChar,50),
new SqlParameter("@TypeId", SqlDbType.Decimal,9),
new SqlParameter("@Message", SqlDbType.NVarChar,2000),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@UserId", SqlDbType.Decimal,9),
new SqlParameter("@Detail", SqlDbType.NVarChar,2000),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Type;
parameters[1].Value = model.TypeId;
parameters[2].Value = model.Message;
parameters[3].Value = model.AddDate;
parameters[4].Value = model.UserId;
parameters[5].Value = model.Detail;
parameters[6].Value = model.Id;
int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(PCMLib.Model.MaterialDetail model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.MaterialDetail model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(PCMLib.Model.AmountInfo model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(PCMLib.Model.Purchase model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.AmountInfo model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(PCMLib.Model.Construction model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbl_Construction(");
strSql.Append("Ct_PID,Ct_Way,Ct_CcID,Ct_Company,Ct_Type,Ct_Leader,Ct_Count,Ct_Address,Ct_Content,Ct_SDate,Ct_EDate,Ct_Time,Ct_ActualEDate,Ct_SignDate,Ct_CompleteRate,Ct_File,Ct_Remark,Ct_EditDate,Ct_Editer,Ct_InputDate,Ct_Inputer,Ct_State)");
strSql.Append(" values (");
strSql.Append("@Ct_PID,@Ct_Way,@Ct_CcID,@Ct_Company,@Ct_Type,@Ct_Leader,@Ct_Count,@Ct_Address,@Ct_Content,@Ct_SDate,@Ct_EDate,@Ct_Time,@Ct_ActualEDate,@Ct_SignDate,@Ct_CompleteRate,@Ct_File,@Ct_Remark,@Ct_EditDate,@Ct_Editer,@Ct_InputDate,@Ct_Inputer,@Ct_State)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Ct_PID", SqlDbType.Decimal,9),
new SqlParameter("@Ct_Way", SqlDbType.Int,4),
new SqlParameter("@Ct_CcID", SqlDbType.Decimal,9),
new SqlParameter("@Ct_Company", SqlDbType.NVarChar,50),
new SqlParameter("@Ct_Type", SqlDbType.Int,4),
new SqlParameter("@Ct_Leader", SqlDbType.VarChar,50),
new SqlParameter("@Ct_Count", SqlDbType.Int,4),
new SqlParameter("@Ct_Address", SqlDbType.VarChar,500),
new SqlParameter("@Ct_Content", SqlDbType.VarChar,500),
new SqlParameter("@Ct_SDate", SqlDbType.DateTime),
new SqlParameter("@Ct_EDate", SqlDbType.DateTime),
new SqlParameter("@Ct_Time", SqlDbType.Int,4),
new SqlParameter("@Ct_ActualEDate", SqlDbType.DateTime),
new SqlParameter("@Ct_SignDate", SqlDbType.DateTime),
new SqlParameter("@Ct_CompleteRate", SqlDbType.Decimal,9),
new SqlParameter("@Ct_File", SqlDbType.NVarChar,50),
new SqlParameter("@Ct_Remark", SqlDbType.NVarChar,500),
new SqlParameter("@Ct_EditDate", SqlDbType.DateTime),
new SqlParameter("@Ct_Editer", SqlDbType.Decimal,9),
new SqlParameter("@Ct_InputDate", SqlDbType.DateTime),
new SqlParameter("@Ct_Inputer", SqlDbType.Decimal,9),
new SqlParameter("@Ct_State", SqlDbType.Int,4)};
parameters[0].Value = model.Ct_PID;
parameters[1].Value = model.Ct_Way;
parameters[2].Value = model.Ct_CcID;
parameters[3].Value = model.Ct_Company;
parameters[4].Value = model.Ct_Type;
parameters[5].Value = model.Ct_Leader;
parameters[6].Value = model.Ct_Count;
parameters[7].Value = model.Ct_Address;
parameters[8].Value = model.Ct_Content;
parameters[9].Value = model.Ct_SDate;
parameters[10].Value = model.Ct_EDate;
parameters[11].Value = model.Ct_Time;
parameters[12].Value = model.Ct_ActualEDate;
parameters[13].Value = model.Ct_SignDate;
parameters[14].Value = model.Ct_CompleteRate;
parameters[15].Value = model.Ct_File;
parameters[16].Value = model.Ct_Remark;
parameters[17].Value = model.Ct_EditDate;
parameters[18].Value = model.Ct_Editer;
parameters[19].Value = model.Ct_InputDate;
parameters[20].Value = model.Ct_Inputer;
parameters[21].Value = model.Ct_State;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToDecimal(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(PCMLib.Model.LogOperation model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.Construction model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbl_Construction set ");
strSql.Append("Ct_PID=@Ct_PID,");
strSql.Append("Ct_Way=@Ct_Way,");
strSql.Append("Ct_CcID=@Ct_CcID,");
strSql.Append("Ct_Company=@Ct_Company,");
strSql.Append("Ct_Type=@Ct_Type,");
strSql.Append("Ct_Leader=@Ct_Leader,");
strSql.Append("Ct_Count=@Ct_Count,");
strSql.Append("Ct_Address=@Ct_Address,");
strSql.Append("Ct_Content=@Ct_Content,");
strSql.Append("Ct_SDate=@Ct_SDate,");
strSql.Append("Ct_EDate=@Ct_EDate,");
strSql.Append("Ct_Time=@Ct_Time,");
strSql.Append("Ct_ActualEDate=@Ct_ActualEDate,");
strSql.Append("Ct_SignDate=@Ct_SignDate,");
strSql.Append("Ct_CompleteRate=@Ct_CompleteRate,");
strSql.Append("Ct_File=@Ct_File,");
strSql.Append("Ct_Remark=@Ct_Remark,");
strSql.Append("Ct_EditDate=@Ct_EditDate,");
strSql.Append("Ct_Editer=@Ct_Editer,");
strSql.Append("Ct_InputDate=@Ct_InputDate,");
strSql.Append("Ct_Inputer=@Ct_Inputer,");
strSql.Append("Ct_State=@Ct_State");
strSql.Append(" where Ct_ID=@Ct_ID");
SqlParameter[] parameters = {
new SqlParameter("@Ct_PID", SqlDbType.Decimal,9),
new SqlParameter("@Ct_Way", SqlDbType.Int,4),
new SqlParameter("@Ct_CcID", SqlDbType.Decimal,9),
new SqlParameter("@Ct_Company", SqlDbType.NVarChar,50),
new SqlParameter("@Ct_Type", SqlDbType.Int,4),
new SqlParameter("@Ct_Leader", SqlDbType.VarChar,50),
new SqlParameter("@Ct_Count", SqlDbType.Int,4),
new SqlParameter("@Ct_Address", SqlDbType.VarChar,500),
new SqlParameter("@Ct_Content", SqlDbType.VarChar,500),
new SqlParameter("@Ct_SDate", SqlDbType.DateTime),
new SqlParameter("@Ct_EDate", SqlDbType.DateTime),
new SqlParameter("@Ct_Time", SqlDbType.Int,4),
new SqlParameter("@Ct_ActualEDate", SqlDbType.DateTime),
new SqlParameter("@Ct_SignDate", SqlDbType.DateTime),
new SqlParameter("@Ct_CompleteRate", SqlDbType.Decimal,9),
new SqlParameter("@Ct_File", SqlDbType.NVarChar,50),
new SqlParameter("@Ct_Remark", SqlDbType.NVarChar,500),
new SqlParameter("@Ct_EditDate", SqlDbType.DateTime),
new SqlParameter("@Ct_Editer", SqlDbType.Decimal,9),
new SqlParameter("@Ct_InputDate", SqlDbType.DateTime),
new SqlParameter("@Ct_Inputer", SqlDbType.Decimal,9),
new SqlParameter("@Ct_State", SqlDbType.Int,4),
new SqlParameter("@Ct_ID", SqlDbType.Decimal,9)};
parameters[0].Value = model.Ct_PID;
parameters[1].Value = model.Ct_Way;
parameters[2].Value = model.Ct_CcID;
parameters[3].Value = model.Ct_Company;
parameters[4].Value = model.Ct_Type;
parameters[5].Value = model.Ct_Leader;
parameters[6].Value = model.Ct_Count;
parameters[7].Value = model.Ct_Address;
parameters[8].Value = model.Ct_Content;
parameters[9].Value = model.Ct_SDate;
parameters[10].Value = model.Ct_EDate;
parameters[11].Value = model.Ct_Time;
parameters[12].Value = model.Ct_ActualEDate;
parameters[13].Value = model.Ct_SignDate;
parameters[14].Value = model.Ct_CompleteRate;
parameters[15].Value = model.Ct_File;
parameters[16].Value = model.Ct_Remark;
parameters[17].Value = model.Ct_EditDate;
parameters[18].Value = model.Ct_Editer;
parameters[19].Value = model.Ct_InputDate;
parameters[20].Value = model.Ct_Inputer;
parameters[21].Value = model.Ct_State;
parameters[22].Value = model.Ct_ID;
int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.MaterialDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbl_MaterialDetail set ");
strSql.Append("Md_PcID=@Md_PcID,");
strSql.Append("Md_Name=@Md_Name,");
strSql.Append("Md_Brand=@Md_Brand,");
strSql.Append("Md_Size=@Md_Size,");
strSql.Append("Md_Price=@Md_Price,");
strSql.Append("Md_Count=@Md_Count,");
strSql.Append("Md_Total=@Md_Total,");
strSql.Append("Md_Seller=@Md_Seller,");
strSql.Append("Md_Contact=@Md_Contact,");
strSql.Append("Md_ContactTel=@Md_ContactTel,");
strSql.Append("Md_Date=@Md_Date,");
strSql.Append("Md_State=@Md_State,");
strSql.Append("Md_Remark=@Md_Remark,");
strSql.Append("Md_Inputer=@Md_Inputer,");
strSql.Append("Md_InputDate=@Md_InputDate,");
strSql.Append("Md_Editer=@Md_Editer,");
strSql.Append("Md_EditDate=@Md_EditDate");
strSql.Append(" where Md_ID=@Md_ID");
SqlParameter[] parameters = {
new SqlParameter("@Md_PcID", SqlDbType.Decimal,9),
new SqlParameter("@Md_Name", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Brand", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Size", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Price", SqlDbType.Decimal,9),
new SqlParameter("@Md_Count", SqlDbType.Int,4),
new SqlParameter("@Md_Total", SqlDbType.Decimal,9),
new SqlParameter("@Md_Seller", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Contact", SqlDbType.NVarChar,50),
new SqlParameter("@Md_ContactTel", SqlDbType.NVarChar,50),
new SqlParameter("@Md_Date", SqlDbType.DateTime),
new SqlParameter("@Md_State", SqlDbType.Int,4),
new SqlParameter("@Md_Remark", SqlDbType.NVarChar,500),
new SqlParameter("@Md_Inputer", SqlDbType.Decimal,9),
new SqlParameter("@Md_InputDate", SqlDbType.DateTime),
new SqlParameter("@Md_Editer", SqlDbType.Decimal,9),
new SqlParameter("@Md_EditDate", SqlDbType.DateTime),
new SqlParameter("@Md_ID", SqlDbType.Decimal,9)};
parameters[0].Value = model.Md_PcID;
parameters[1].Value = model.Md_Name;
parameters[2].Value = model.Md_Brand;
parameters[3].Value = model.Md_Size;
parameters[4].Value = model.Md_Price;
parameters[5].Value = model.Md_Count;
parameters[6].Value = model.Md_Total;
parameters[7].Value = model.Md_Seller;
parameters[8].Value = model.Md_Contact;
parameters[9].Value = model.Md_ContactTel;
parameters[10].Value = model.Md_Date;
parameters[11].Value = model.Md_State;
parameters[12].Value = model.Md_Remark;
parameters[13].Value = model.Md_Inputer;
parameters[14].Value = model.Md_InputDate;
parameters[15].Value = model.Md_Editer;
parameters[16].Value = model.Md_EditDate;
parameters[17].Value = model.Md_ID;
int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PCMLib.Model.Completion model)
{
return dal.Update(model);
}