public InExPlanModel ReaderBind(IDataReader dataReader)
{
InExPlanModel model = new InExPlanModel();
if (dataReader["ID"].ToString() != "")
{
model.ID = dataReader["ID"].ToString();
}
model.IEPNum = dataReader["IEPNum"].ToString();
model.IEPname = dataReader["IEPname"].ToString();
if (dataReader["IEPtype"].ToString() != "")
{
model.IEPtype = new int?(int.Parse(dataReader["IEPtype"].ToString()));
}
if (dataReader["IEPdate"].ToString() != "")
{
model.IEPdate = new DateTime?(DateTime.Parse(dataReader["IEPdate"].ToString()));
}
model.prjNum = dataReader["prjNum"].ToString();
if (dataReader["state"].ToString() != "")
{
model.state = new int?(int.Parse(dataReader["state"].ToString()));
}
return(model);
}
public int Update(SqlTransaction trans, InExPlanModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update fund_InExPlan set ");
builder.Append("IEPNum=@IEPNum,");
builder.Append("IEPname=@IEPname,");
builder.Append("IEPtype=@IEPtype,");
builder.Append("IEPdate=@IEPdate,");
builder.Append("prjNum=@prjNum,");
builder.Append("state=@state");
builder.Append(" where ID=@ID ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@IEPNum", SqlDbType.NVarChar, 50), new SqlParameter("@IEPname", SqlDbType.NVarChar, 50), new SqlParameter("@IEPtype", SqlDbType.Int, 4), new SqlParameter("@IEPdate", SqlDbType.DateTime), new SqlParameter("@prjNum", SqlDbType.NVarChar, 0x40), new SqlParameter("@state", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.IEPNum;
commandParameters[1].Value = model.IEPname;
commandParameters[2].Value = model.IEPtype;
commandParameters[3].Value = model.IEPdate;
commandParameters[4].Value = model.prjNum;
commandParameters[5].Value = model.state;
commandParameters[6].Value = model.ID;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public InExPlanModel GetModel(string ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 ID,IEPNum,IEPname,IEPtype,IEPdate,prjNum,state from fund_InExPlan ");
builder.Append(" where ID=@ID ");
InExPlanModel 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(SqlTransaction trans, InExPlanModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into fund_InExPlan(");
builder.Append("ID,IEPNum,IEPname,IEPtype,IEPdate,prjNum,state)");
builder.Append(" values (");
builder.Append("@ID,@IEPNum,@IEPname,@IEPtype,@IEPdate,@prjNum,@state)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x40), new SqlParameter("@IEPNum", SqlDbType.NVarChar, 50), new SqlParameter("@IEPname", SqlDbType.NVarChar, 50), new SqlParameter("@IEPtype", SqlDbType.Int, 4), new SqlParameter("@IEPdate", SqlDbType.DateTime), new SqlParameter("@prjNum", SqlDbType.NVarChar, 0x40), new SqlParameter("@state", SqlDbType.Int, 4) };
commandParameters[0].Value = model.ID;
commandParameters[1].Value = model.IEPNum;
commandParameters[2].Value = model.IEPname;
commandParameters[3].Value = model.IEPtype;
commandParameters[4].Value = model.IEPdate;
commandParameters[5].Value = model.prjNum;
commandParameters[6].Value = model.state;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
