public int Update(PayendFeedbackModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Con_PayendFeedback set ");
builder.Append("ContractID=@ContractID,");
builder.Append("FeedbackPerson=@FeedbackPerson,");
builder.Append("FeedbackTime=@FeedbackTime,");
builder.Append("FeedbackOpinion=@FeedbackOpinion,");
builder.Append("Annex=@Annex,");
builder.Append("InPerson=@InPerson,");
builder.Append("InTime=@InTime,");
builder.Append("FeedbackState=@FeedbackState");
builder.Append(" where ID=@ID ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@FeedbackPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@FeedbackTime", SqlDbType.DateTime), new SqlParameter("@FeedbackOpinion", SqlDbType.NVarChar), new SqlParameter("@Annex", SqlDbType.NVarChar, 200), new SqlParameter("@InPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@InTime", SqlDbType.DateTime), new SqlParameter("@FeedbackState", SqlDbType.NVarChar, 10) };
commandParameters[0].Value = model.ID;
commandParameters[1].Value = model.ContractID;
commandParameters[2].Value = model.FeedbackPerson;
commandParameters[3].Value = model.FeedbackTime;
commandParameters[4].Value = model.FeedbackOpinion;
commandParameters[5].Value = model.Annex;
commandParameters[6].Value = model.InPerson;
commandParameters[7].Value = model.InTime;
commandParameters[8].Value = model.FeedbackState;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public int AddModel(string contractId)
{
PayendFeedbackModel payendFeedbackModel = new PayendFeedbackModel();
payendFeedbackModel.Annex = "";
payendFeedbackModel.ContractID = contractId;
payendFeedbackModel.FeedbackOpinion = "";
payendFeedbackModel.FeedbackPerson = base.UserCode;
payendFeedbackModel.FeedbackState = "1";
payendFeedbackModel.FeedbackTime = new DateTime?(DateTime.Now);
payendFeedbackModel.ID = Guid.NewGuid().ToString();
payendFeedbackModel.InPerson = PageHelper.QueryUser(this, base.UserCode);
payendFeedbackModel.InTime = new DateTime?(DateTime.Now);
return(this.payendFeedbackBll.Add(payendFeedbackModel));
}
public PayendFeedbackModel GetModel(string ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ID,ContractID,FeedbackPerson,FeedbackTime,FeedbackOpinion,Annex,InPerson,InTime,FeedbackState from Con_PayendFeedback ");
builder.Append(" where ID=@ID ");
PayendFeedbackModel model = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@ID", ID) }))
{
if (reader.Read())
{
model = this.ReaderBind(reader);
}
}
return(model);
}
public int Add(PayendFeedbackModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Con_PayendFeedback(");
builder.Append("ID,ContractID,FeedbackPerson,FeedbackTime,FeedbackOpinion,Annex,InPerson,InTime,FeedbackState)");
builder.Append(" values (");
builder.Append("@ID,@ContractID,@FeedbackPerson,@FeedbackTime,@FeedbackOpinion,@Annex,@InPerson,@InTime,@FeedbackState)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x40), new SqlParameter("@ContractID", SqlDbType.NVarChar, 0x40), new SqlParameter("@FeedbackPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@FeedbackTime", SqlDbType.DateTime), new SqlParameter("@FeedbackOpinion", SqlDbType.NVarChar), new SqlParameter("@Annex", SqlDbType.NVarChar, 200), new SqlParameter("@InPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@InTime", SqlDbType.DateTime), new SqlParameter("@FeedbackState", SqlDbType.NVarChar, 10) };
commandParameters[0].Value = model.ID;
commandParameters[1].Value = model.ContractID;
commandParameters[2].Value = model.FeedbackPerson;
commandParameters[3].Value = model.FeedbackTime;
commandParameters[4].Value = model.FeedbackOpinion;
commandParameters[5].Value = model.Annex;
commandParameters[6].Value = model.InPerson;
commandParameters[7].Value = model.InTime;
commandParameters[8].Value = model.FeedbackState;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public PayendFeedbackModel ReaderBind(IDataReader dataReader)
{
PayendFeedbackModel model = new PayendFeedbackModel {
ID = dataReader["ID"].ToString(),
ContractID = dataReader["ContractID"].ToString(),
FeedbackPerson = dataReader["FeedbackPerson"].ToString()
};
object obj2 = dataReader["FeedbackTime"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.FeedbackTime = new DateTime?((DateTime)obj2);
}
model.FeedbackOpinion = dataReader["FeedbackOpinion"].ToString();
model.Annex = dataReader["Annex"].ToString();
model.InPerson = dataReader["InPerson"].ToString();
obj2 = dataReader["InTime"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.InTime = new DateTime?((DateTime)obj2);
}
model.FeedbackState = dataReader["FeedbackState"].ToString();
return(model);
}
public int Update(PayendFeedbackModel model)
{
return(this.payendFeedback.Update(model));
}
public int Add(PayendFeedbackModel model)
{
return(this.payendFeedback.Add(model));
}
