/// <summary>
/// 获得数据列表
/// </summary>
public List <Model.ZZ_DIC_UNDERTAKER> DataTableToList(DataTable dt)
{
List <Model.ZZ_DIC_UNDERTAKER> modelList = new List <Model.ZZ_DIC_UNDERTAKER>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Model.ZZ_DIC_UNDERTAKER model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.ZZ_DIC_UNDERTAKER();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = decimal.Parse(dt.Rows[n]["ID"].ToString());
}
model.JIGMC = dt.Rows[n]["JIGMC"].ToString();
model.JIANC = dt.Rows[n]["JIANC"].ToString();
if (dt.Rows[n]["STATES"].ToString() != "")
{
model.STATES = decimal.Parse(dt.Rows[n]["STATES"].ToString());
}
model.REMARKS = dt.Rows[n]["REMARKS"].ToString();
model.CREATE_PEOPLE = dt.Rows[n]["CREATE_PEOPLE"].ToString();
if (dt.Rows[n]["CREATE_DATE"].ToString() != "")
{
model.CREATE_DATE = DateTime.Parse(dt.Rows[n]["CREATE_DATE"].ToString());
}
model.MODIFY_PEOPLE = dt.Rows[n]["MODIFY_PEOPLE"].ToString();
if (dt.Rows[n]["MODIFY_DATE"].ToString() != "")
{
model.MODIFY_DATE = DateTime.Parse(dt.Rows[n]["MODIFY_DATE"].ToString());
}
model.SHANGJBM = dt.Rows[n]["SHANGJBM"].ToString();
model.BIANM = dt.Rows[n]["BIANM"].ToString();
if (dt.Rows[n]["PARENTID"].ToString() != "")
{
model.PARENTID = decimal.Parse(dt.Rows[n]["PARENTID"].ToString());
}
model.ZHIDUIID = dt.Rows[n]["ZHIDUIID"].ToString();
if (dt.Rows[n]["TYPE"].ToString() != "")
{
model.TYPE = decimal.Parse(dt.Rows[n]["TYPE"].ToString());
}
if (dt.Rows[n]["ORDERNUM"].ToString() != "")
{
model.ORDERNUM = decimal.Parse(dt.Rows[n]["ORDERNUM"].ToString());
}
model.DIANXINBUMEN = dt.Rows[n]["DIANXINBUMEN"].ToString();
model.GUID = dt.Rows[n]["GUID"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.ZZ_DIC_UNDERTAKER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ZZ_DIC_UNDERTAKER(");
strSql.Append("ID,JIGMC,JIANC,STATES,REMARKS,CREATE_PEOPLE,CREATE_DATE,MODIFY_PEOPLE,MODIFY_DATE,SHANGJBM,BIANM,PARENTID,ZHIDUIID,TYPE,ORDERNUM,DIANXINBUMEN,GUID");
strSql.Append(") values (");
strSql.Append(":ID,:JIGMC,:JIANC,:STATES,:REMARKS,:CREATE_PEOPLE,:CREATE_DATE,:MODIFY_PEOPLE,:MODIFY_DATE,:SHANGJBM,:BIANM,:PARENTID,:ZHIDUIID,:TYPE,:ORDERNUM,:DIANXINBUMEN,:GUID");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleDbType.Int32, 4),
new OracleParameter(":JIGMC", OracleDbType.Varchar2, 100),
new OracleParameter(":JIANC", OracleDbType.Varchar2, 100),
new OracleParameter(":STATES", OracleDbType.Int32, 4),
new OracleParameter(":REMARKS", OracleDbType.Varchar2, 100),
new OracleParameter(":CREATE_PEOPLE", OracleDbType.Varchar2, 100),
new OracleParameter(":CREATE_DATE", OracleDbType.Date),
new OracleParameter(":MODIFY_PEOPLE", OracleDbType.Varchar2, 100),
new OracleParameter(":MODIFY_DATE", OracleDbType.Date),
new OracleParameter(":SHANGJBM", OracleDbType.Varchar2, 100),
new OracleParameter(":BIANM", OracleDbType.Varchar2, 100),
new OracleParameter(":PARENTID", OracleDbType.Int32, 4),
new OracleParameter(":ZHIDUIID", OracleDbType.Varchar2, 100),
new OracleParameter(":TYPE", OracleDbType.Int32, 4),
new OracleParameter(":ORDERNUM", OracleDbType.Int32, 4),
new OracleParameter(":DIANXINBUMEN", OracleDbType.Varchar2, 100),
new OracleParameter(":GUID", OracleDbType.Varchar2, 36)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.JIGMC;
parameters[2].Value = model.JIANC;
parameters[3].Value = model.STATES;
parameters[4].Value = model.REMARKS;
parameters[5].Value = model.CREATE_PEOPLE;
parameters[6].Value = model.CREATE_DATE;
parameters[7].Value = model.MODIFY_PEOPLE;
parameters[8].Value = model.MODIFY_DATE;
parameters[9].Value = model.SHANGJBM;
parameters[10].Value = model.BIANM;
parameters[11].Value = model.PARENTID;
parameters[12].Value = model.ZHIDUIID;
parameters[13].Value = model.TYPE;
parameters[14].Value = model.ORDERNUM;
parameters[15].Value = model.DIANXINBUMEN;
parameters[16].Value = model.GUID;
DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.ZZ_DIC_UNDERTAKER model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.ZZ_DIC_UNDERTAKER model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.ZZ_DIC_UNDERTAKER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ZZ_DIC_UNDERTAKER set ");
strSql.Append(" ID = :ID , ");
strSql.Append(" JIGMC = :JIGMC , ");
strSql.Append(" JIANC = :JIANC , ");
strSql.Append(" STATES = :STATES , ");
strSql.Append(" REMARKS = :REMARKS , ");
strSql.Append(" CREATE_PEOPLE = :CREATE_PEOPLE , ");
strSql.Append(" CREATE_DATE = :CREATE_DATE , ");
strSql.Append(" MODIFY_PEOPLE = :MODIFY_PEOPLE , ");
strSql.Append(" MODIFY_DATE = :MODIFY_DATE , ");
strSql.Append(" SHANGJBM = :SHANGJBM , ");
strSql.Append(" BIANM = :BIANM , ");
strSql.Append(" PARENTID = :PARENTID , ");
strSql.Append(" ZHIDUIID = :ZHIDUIID , ");
strSql.Append(" TYPE = :TYPE , ");
strSql.Append(" ORDERNUM = :ORDERNUM , ");
strSql.Append(" DIANXINBUMEN = :DIANXINBUMEN , ");
strSql.Append(" GUID = :GUID ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleDbType.Int32, 4),
new OracleParameter(":JIGMC", OracleDbType.Varchar2, 100),
new OracleParameter(":JIANC", OracleDbType.Varchar2, 100),
new OracleParameter(":STATES", OracleDbType.Int32, 4),
new OracleParameter(":REMARKS", OracleDbType.Varchar2, 100),
new OracleParameter(":CREATE_PEOPLE", OracleDbType.Varchar2, 100),
new OracleParameter(":CREATE_DATE", OracleDbType.Date),
new OracleParameter(":MODIFY_PEOPLE", OracleDbType.Varchar2, 100),
new OracleParameter(":MODIFY_DATE", OracleDbType.Date),
new OracleParameter(":SHANGJBM", OracleDbType.Varchar2, 100),
new OracleParameter(":BIANM", OracleDbType.Varchar2, 100),
new OracleParameter(":PARENTID", OracleDbType.Int32, 4),
new OracleParameter(":ZHIDUIID", OracleDbType.Varchar2, 100),
new OracleParameter(":TYPE", OracleDbType.Int32, 4),
new OracleParameter(":ORDERNUM", OracleDbType.Int32, 4),
new OracleParameter(":DIANXINBUMEN", OracleDbType.Varchar2, 100),
new OracleParameter(":GUID", OracleDbType.Varchar2, 36)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.JIGMC;
parameters[2].Value = model.JIANC;
parameters[3].Value = model.STATES;
parameters[4].Value = model.REMARKS;
parameters[5].Value = model.CREATE_PEOPLE;
parameters[6].Value = model.CREATE_DATE;
parameters[7].Value = model.MODIFY_PEOPLE;
parameters[8].Value = model.MODIFY_DATE;
parameters[9].Value = model.SHANGJBM;
parameters[10].Value = model.BIANM;
parameters[11].Value = model.PARENTID;
parameters[12].Value = model.ZHIDUIID;
parameters[13].Value = model.TYPE;
parameters[14].Value = model.ORDERNUM;
parameters[15].Value = model.DIANXINBUMEN;
parameters[16].Value = model.GUID;
int rows = DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ZZ_DIC_UNDERTAKER GetModel()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, JIGMC, JIANC, STATES, REMARKS, CREATE_PEOPLE, CREATE_DATE, MODIFY_PEOPLE, MODIFY_DATE, SHANGJBM, BIANM, PARENTID, ZHIDUIID, TYPE, ORDERNUM, DIANXINBUMEN, GUID ");
strSql.Append(" from ZZ_DIC_UNDERTAKER ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
};
Model.ZZ_DIC_UNDERTAKER model = new Model.ZZ_DIC_UNDERTAKER();
DataSet ds = DbHelperOra_new.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = decimal.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.JIGMC = ds.Tables[0].Rows[0]["JIGMC"].ToString();
model.JIANC = ds.Tables[0].Rows[0]["JIANC"].ToString();
if (ds.Tables[0].Rows[0]["STATES"].ToString() != "")
{
model.STATES = decimal.Parse(ds.Tables[0].Rows[0]["STATES"].ToString());
}
model.REMARKS = ds.Tables[0].Rows[0]["REMARKS"].ToString();
model.CREATE_PEOPLE = ds.Tables[0].Rows[0]["CREATE_PEOPLE"].ToString();
if (ds.Tables[0].Rows[0]["CREATE_DATE"].ToString() != "")
{
model.CREATE_DATE = DateTime.Parse(ds.Tables[0].Rows[0]["CREATE_DATE"].ToString());
}
model.MODIFY_PEOPLE = ds.Tables[0].Rows[0]["MODIFY_PEOPLE"].ToString();
if (ds.Tables[0].Rows[0]["MODIFY_DATE"].ToString() != "")
{
model.MODIFY_DATE = DateTime.Parse(ds.Tables[0].Rows[0]["MODIFY_DATE"].ToString());
}
model.SHANGJBM = ds.Tables[0].Rows[0]["SHANGJBM"].ToString();
model.BIANM = ds.Tables[0].Rows[0]["BIANM"].ToString();
if (ds.Tables[0].Rows[0]["PARENTID"].ToString() != "")
{
model.PARENTID = decimal.Parse(ds.Tables[0].Rows[0]["PARENTID"].ToString());
}
model.ZHIDUIID = ds.Tables[0].Rows[0]["ZHIDUIID"].ToString();
if (ds.Tables[0].Rows[0]["TYPE"].ToString() != "")
{
model.TYPE = decimal.Parse(ds.Tables[0].Rows[0]["TYPE"].ToString());
}
if (ds.Tables[0].Rows[0]["ORDERNUM"].ToString() != "")
{
model.ORDERNUM = decimal.Parse(ds.Tables[0].Rows[0]["ORDERNUM"].ToString());
}
model.DIANXINBUMEN = ds.Tables[0].Rows[0]["DIANXINBUMEN"].ToString();
model.GUID = ds.Tables[0].Rows[0]["GUID"].ToString();
return(model);
}
else
{
return(null);
}
}
