public int Update(ptOfficeResStockCheckDetail model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_OfficeRes_StockCheck_Detail set ");
builder.Append("CheckRecordID=" + model.CheckRecordID + ",");
builder.Append("MaterialID=" + model.MaterialID + ",");
builder.Append("AccountNumber=" + model.AccountNumber + ",");
builder.Append("CheckNumber=" + model.CheckNumber + ",");
builder.Append("Remark='" + model.Remark + "'");
builder.Append(" where CheckDetailID=" + model.CheckDetailID);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public ptOfficeResStockCheckDetail GetModel(int CheckDetailID)
{
StringBuilder builder = new StringBuilder();
builder.Append(" select CheckDetailID,CheckRecordID,MaterialID,AccountNumber,CheckNumber,Remark ");
builder.Append(" from OA_OfficeRes_StockCheck_Detail ");
builder.Append(" where CheckDetailID=" + CheckDetailID);
ptOfficeResStockCheckDetail detail = new ptOfficeResStockCheckDetail();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["CheckDetailID"].ToString() != "")
{
detail.CheckDetailID = int.Parse(set.Tables[0].Rows[0]["CheckDetailID"].ToString());
}
if (set.Tables[0].Rows[0]["CheckRecordID"].ToString() != "")
{
detail.CheckRecordID = int.Parse(set.Tables[0].Rows[0]["CheckRecordID"].ToString());
}
if (set.Tables[0].Rows[0]["MaterialID"].ToString() != "")
{
detail.MaterialID = int.Parse(set.Tables[0].Rows[0]["MaterialID"].ToString());
}
if (set.Tables[0].Rows[0]["AccountNumber"].ToString() != "")
{
detail.AccountNumber = decimal.Parse(set.Tables[0].Rows[0]["AccountNumber"].ToString());
}
if (set.Tables[0].Rows[0]["CheckNumber"].ToString() != "")
{
detail.CheckNumber = decimal.Parse(set.Tables[0].Rows[0]["CheckNumber"].ToString());
}
detail.Remark = set.Tables[0].Rows[0]["Remark"].ToString();
return(detail);
}
