/// <summary>
/// 插入一条明细记录
/// </summary>
/// <param name="OprObject"></param>
/// <returns></returns>
public int Insert(clsStockRecord OprObject, out string sErrMsg)
{
sErrMsg = string.Empty;
int rtn = 0;
try
{
string insertSql = "insert into tStockRecord(SysCode,StdCode,CompanyID,CompanyName,DisplayName,InputDate,FoodID,FoodName,Model,InputNumber,OutputNumber,Unit,ProduceDate,ExpirationDate,ProduceCompanyID,ProduceCompanyName,PrivoderID,PrivoderName,LinkInfo,LinkMan,CertificateType1,CertificateType2,CertificateType3,CertificateType4,CertificateType5,CertificateType6,CertificateType7,CertificateType8,CertificateType9,CertificateInfo,MakeMan,Remark,DistrictCode)"
+ " values('"
+ OprObject.SysCode + "','"
+ OprObject.StdCode + "','"
+ OprObject.CompanyID + "','"
+ OprObject.CompanyName + "','"
+ OprObject.DisplayName + "','"
+ OprObject.InputDate + "','"
+ OprObject.FoodID + "','"
+ OprObject.FoodName + "','"
+ OprObject.Model + "',"
+ OprObject.InputNumber + ","
+ OprObject.OutputNumber + ",'"
+ OprObject.Unit + "','"
+ OprObject.ProduceDate + "','"
+ OprObject.ExpirationDate + "','"
+ OprObject.ProduceCompanyID + "','"
+ OprObject.ProduceCompanyName + "','"
+ OprObject.PrivoderID + "','"
+ OprObject.PrivoderName + "','"
+ OprObject.LinkInfo + "','"
+ OprObject.LinkMan + "','"
+ OprObject.CertificateType1 + "','"
+ OprObject.CertificateType2 + "','"
+ OprObject.CertificateType3 + "','"
+ OprObject.CertificateType4 + "','"
+ OprObject.CertificateType5 + "','"
+ OprObject.CertificateType6 + "','"
+ OprObject.CertificateType7 + "','"
+ OprObject.CertificateType8 + "','"
+ OprObject.CertificateType9 + "','"
+ OprObject.CertificateInfo + "','"
+ OprObject.MakeMan + "','"
+ OprObject.Remark + "','"
+ OprObject.DistrictCode + "')";
DataBase.ExecuteCommand(insertSql, out sErrMsg);
rtn = 1;
}
catch (Exception e)
{
// Log.WriteLog("添加tSaleRecord",e);
sErrMsg = e.Message;
}
return(rtn);
}
/// <summary>
/// 部分修改保存
/// </summary>
/// <param name="OprObject">对象clsStockRecord的一个实例参数</param>
/// <returns></returns>
public int UpdatePart(clsStockRecord OprObject, string sOldCode, out string sErrMsg)
{
sErrMsg = string.Empty;
int rtn = 0;
try
{
string updateSql = "update tStockRecord set "
+ "StdCode='" + OprObject.StdCode + "',"
+ "CompanyID='" + OprObject.CompanyID + "',"
+ "CompanyName='" + OprObject.CompanyName + "',"
+ "DisplayName='" + OprObject.DisplayName + "',"
+ "InputDate='" + OprObject.InputDate + "',"
+ "FoodID='" + OprObject.FoodID + "',"
+ "FoodName='" + OprObject.FoodName + "',"
+ "Model='" + OprObject.Model + "',"
+ "InputNumber=" + OprObject.InputNumber + ","
+ "OutputNumber=" + OprObject.OutputNumber + ","
+ "Unit='" + OprObject.Unit + "',"
+ "ProduceDate='" + OprObject.ProduceDate + "',"
+ "ExpirationDate='" + OprObject.ExpirationDate + "',"
+ "ProduceCompanyID='" + OprObject.ProduceCompanyID + "',"
+ "ProduceCompanyName='" + OprObject.ProduceCompanyName + "',"
+ "PrivoderID='" + OprObject.PrivoderID + "',"
+ "PrivoderName='" + OprObject.PrivoderName + "',"
+ "LinkInfo='" + OprObject.LinkInfo + "',"
+ "LinkMan='" + OprObject.LinkMan + "',"
+ "CertificateType1='" + OprObject.CertificateType1 + "',"
+ "CertificateType2='" + OprObject.CertificateType2 + "',"
+ "CertificateType3='" + OprObject.CertificateType3 + "',"
+ "CertificateType4='" + OprObject.CertificateType4 + "',"
+ "CertificateType5='" + OprObject.CertificateType5 + "',"
+ "CertificateType6='" + OprObject.CertificateType6 + "',"
+ "CertificateType7='" + OprObject.CertificateType7 + "',"
+ "CertificateType8='" + OprObject.CertificateType8 + "',"
+ "CertificateType9='" + OprObject.CertificateType9 + "',"
+ "CertificateInfo='" + OprObject.CertificateInfo + "',"
+ "MakeMan='" + OprObject.MakeMan + "',"
+ "Remark='" + OprObject.Remark + "',"
+ "DistrictCode='" + OprObject.DistrictCode + "' "
+ " where SysCode='" + sOldCode + "' ";
DataBase.ExecuteCommand(updateSql, out sErrMsg);
rtn = 1;
}
catch (Exception e)
{
// Log.WriteLog("更新tStockRecord",e);
sErrMsg = e.Message;
}
return(rtn);
}