public bool Update(com.jwsoft.pm.entpm.model.InventoryDetail model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update pm_Repe_InventoryDetail set ");
builder.Append("InventoryID=" + model.InventoryID + ",");
builder.Append("MaterialId=" + model.MaterialId + ",");
builder.Append("UnitPrice=" + model.UnitPrice + ",");
builder.Append("BookScalar=" + model.BookScalar + ",");
builder.Append("FactScalar=" + model.FactScalar);
builder.Append(" where InventoryDetailID=" + model.InventoryDetailID + " ");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
public bool Add(com.jwsoft.pm.entpm.model.InventoryDetail model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into pm_Repe_InventoryDetail(");
builder.Append("InventoryID,MaterialId,UnitPrice,BookScalar,FactScalar");
builder.Append(")");
builder.Append(" values (");
builder.Append(model.InventoryID + ",");
builder.Append(model.MaterialId + ",");
builder.Append(model.UnitPrice + ",");
builder.Append(model.BookScalar + ",");
builder.Append(model.FactScalar);
builder.Append(")");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
public com.jwsoft.pm.entpm.model.InventoryDetail GetModel(int InventoryDetailID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" InventoryDetailID,InventoryID,MaterialId,UnitPrice,BookScalar,FactScalar ");
builder.Append(" from pm_Repe_InventoryDetail ");
builder.Append(" where InventoryDetailID=" + InventoryDetailID + " ");
com.jwsoft.pm.entpm.model.InventoryDetail detail = new com.jwsoft.pm.entpm.model.InventoryDetail();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["InventoryDetailID"].ToString() != "")
{
detail.InventoryDetailID = int.Parse(set.Tables[0].Rows[0]["InventoryDetailID"].ToString());
}
if (set.Tables[0].Rows[0]["InventoryID"].ToString() != "")
{
detail.InventoryID = int.Parse(set.Tables[0].Rows[0]["InventoryID"].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]["UnitPrice"].ToString() != "")
{
detail.UnitPrice = decimal.Parse(set.Tables[0].Rows[0]["UnitPrice"].ToString());
}
if (set.Tables[0].Rows[0]["BookScalar"].ToString() != "")
{
detail.BookScalar = decimal.Parse(set.Tables[0].Rows[0]["BookScalar"].ToString());
}
if (set.Tables[0].Rows[0]["FactScalar"].ToString() != "")
{
detail.FactScalar = decimal.Parse(set.Tables[0].Rows[0]["FactScalar"].ToString());
}
return(detail);
}