public com.jwsoft.pm.entpm.model.DepositoryInfo GetModel(int DepositoryID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" DepositoryID,DepoClassID,DepositoryName,DepositoryCode,Purview,Principal,Remark ");
builder.Append(" from pm_Repe_DepositoryInfo ");
builder.Append(" where DepositoryID=" + DepositoryID + " ");
com.jwsoft.pm.entpm.model.DepositoryInfo info = new com.jwsoft.pm.entpm.model.DepositoryInfo();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["DepositoryID"].ToString() != "")
{
info.DepositoryID = int.Parse(set.Tables[0].Rows[0]["DepositoryID"].ToString());
}
if (set.Tables[0].Rows[0]["DepoClassID"].ToString() != "")
{
info.DepoClassID = int.Parse(set.Tables[0].Rows[0]["DepoClassID"].ToString());
}
info.DepositoryName = set.Tables[0].Rows[0]["DepositoryName"].ToString();
info.DepositoryCode = set.Tables[0].Rows[0]["DepositoryCode"].ToString();
info.Purview = set.Tables[0].Rows[0]["Purview"].ToString();
info.Principal = set.Tables[0].Rows[0]["Principal"].ToString();
info.Remark = set.Tables[0].Rows[0]["Remark"].ToString();
return(info);
}
public bool Update(com.jwsoft.pm.entpm.model.DepositoryInfo model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update pm_Repe_DepositoryInfo set ");
builder.Append("DepoClassID=" + model.DepoClassID + ",");
builder.Append("DepositoryName='" + model.DepositoryName + "',");
builder.Append("DepositoryCode='" + model.DepositoryCode + "',");
builder.Append("Purview='" + model.Purview + "',");
builder.Append("Principal='" + model.Principal + "',");
builder.Append("Remark='" + model.Remark + "'");
builder.Append(" where DepositoryID=" + model.DepositoryID + " ");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
public bool Add(com.jwsoft.pm.entpm.model.DepositoryInfo model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into pm_Repe_DepositoryInfo(");
builder.Append("DepoClassID,DepositoryName,DepositoryCode,Purview,Principal,Remark");
builder.Append(")");
builder.Append(" values (");
builder.Append(model.DepoClassID + ",");
builder.Append("'" + model.DepositoryName + "',");
builder.Append("'" + model.DepositoryCode + "',");
builder.Append("'" + model.Purview + "',");
builder.Append("'" + model.Principal + "',");
builder.Append("'" + model.Remark + "'");
builder.Append(")");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
