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())); }