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