public PrvdAccessoryModel GetModel(int AccessoryId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * from pm_prvd_accessory ");
builder.Append(" where AccessoryId=" + AccessoryId);
PrvdAccessoryModel model = new PrvdAccessoryModel();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
model.AccessoryId = AccessoryId;
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["ProviderId"].ToString() != "")
{
model.ProviderId = int.Parse(set.Tables[0].Rows[0]["ProviderId"].ToString());
}
model.AccessoryName = set.Tables[0].Rows[0]["AccessoryName"].ToString();
model.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString();
if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "")
{
model.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString());
}
model.Comment = set.Tables[0].Rows[0]["Comment"].ToString();
return(model);
}
public int Update(PrvdAccessoryModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update pm_prvd_accessory set ");
builder.Append("ProviderId=" + model.ProviderId + ",");
builder.Append("AccessoryName='" + model.AccessoryName + "',");
builder.Append("Comment='" + model.Comment + "'");
builder.Append(" where AccessoryId=" + model.AccessoryId);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(PrvdAccessoryModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into pm_prvd_accessory(");
builder.Append("AccessoryId,ProviderId,AccessoryName,UserCode,OriginalName,FilePath,RecordDate,Comment");
builder.Append(")");
builder.Append(" values (");
builder.Append(model.AccessoryId + ",");
builder.Append(model.ProviderId + ",");
builder.Append("'" + model.AccessoryName + "',");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + model.OriginalName + "',");
builder.Append("'" + model.FilePath + "',");
builder.Append("'" + model.RecordDate + "',");
builder.Append("'" + model.Comment + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
