public int InsertMaterialOut(CMSMStruct.MaterialOutStruct mes)
{
con.Open();
using (SqlTransaction tran = con.BeginTransaction())
{
try
{
string sql1 = "insert into tbMaterialOut values('" + mes.strBatchNo + "'," + mes.strMaterialCode + ",'" + mes.strMaterialName + "','" + mes.strStandardUnit + "','" + mes.strUnit + "'," + mes.dPrice.ToString() + ",'" + mes.strProviderName + "','" + mes.strMaterialType + "'," + mes.dLastCount.ToString() + "," + mes.dOutCount.ToString() + "," + mes.dCount + ",'" + mes.strOperType + "',null,'" + mes.strOutDate + "','" + mes.strDeptID + "','" + mes.strOperDate + "','" + mes.strOperName + "')";
SqlHelper.ExecuteNonQuery(con, tran, CommandType.Text, sql1);
string sql2 = "update tbMaterialPara set cnnCurCount=" + mes.dCount + " where cnvcBatchNo='" + mes.strBatchNo + "' and cnnMaterialCode=" + mes.strMaterialCode;
SqlHelper.ExecuteNonQuery(con, tran, CommandType.Text, sql2);
tran.Commit();
return(1);
}
catch (Exception e)
{
tran.Rollback();
clog.WriteLine(e);
return(0);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}
public bool InsertMaterialOut(CMSMStruct.MaterialOutStruct mes)
{
int recount = msa.InsertMaterialOut(mes);
if (recount <= 0)
{
return(false);
}
return(true);
}
