/// <summary>
/// 得到一个对象实体
/// </summary>
public ERM.MDL.T_Archive Find(string ArchiveID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" ajlx,ajs,ajtm,ArchiveID,bgqx,bz,bzdw,bzrq,cdh,cpz,dh,dpz,dtz,dw,gpz,ljr,lxdh,lydh,mj,orderindex,p,ProjectNO,qt,sl,swp,tzz,wzz,ysfw,z,zpz,jhlx ");
strSql.Append(" from T_Archive ");
strSql.Append(" where ArchiveID='" + ArchiveID + "' ");
ERM.MDL.T_Archive model = new ERM.MDL.T_Archive();
DataSet ds = DbHelperOleDb.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
model.ajlx = ds.Tables[0].Rows[0]["ajlx"].ToString();
model.ajs = ds.Tables[0].Rows[0]["ajs"].ToString();
model.ajtm = ds.Tables[0].Rows[0]["ajtm"].ToString();
model.ArchiveID = ds.Tables[0].Rows[0]["ArchiveID"].ToString();
model.bgqx = ds.Tables[0].Rows[0]["bgqx"].ToString();
model.bz = ds.Tables[0].Rows[0]["bz"].ToString();
model.bzdw = ds.Tables[0].Rows[0]["bzdw"].ToString();
model.bzrq = ds.Tables[0].Rows[0]["bzrq"].ToString();
model.cdh = ds.Tables[0].Rows[0]["cdh"].ToString();
model.cpz = ds.Tables[0].Rows[0]["cpz"].ToString();
model.dh = ds.Tables[0].Rows[0]["dh"].ToString();
model.dpz = ds.Tables[0].Rows[0]["dpz"].ToString();
model.dtz = ds.Tables[0].Rows[0]["dtz"].ToString();
model.dw = ds.Tables[0].Rows[0]["dw"].ToString();
model.gpz = ds.Tables[0].Rows[0]["gpz"].ToString();
model.ljr = ds.Tables[0].Rows[0]["ljr"].ToString();
model.lxdh = ds.Tables[0].Rows[0]["lxdh"].ToString();
model.lydh = ds.Tables[0].Rows[0]["lydh"].ToString();
model.mj = ds.Tables[0].Rows[0]["mj"].ToString();
if (ds.Tables[0].Rows[0]["orderindex"].ToString() != "")
{
model.OrderIndex = int.Parse(ds.Tables[0].Rows[0]["OrderIndex"].ToString());
}
model.p = ds.Tables[0].Rows[0]["p"].ToString();
model.ProjectNO = ds.Tables[0].Rows[0]["ProjectNO"].ToString();
model.qt = ds.Tables[0].Rows[0]["qt"].ToString();
model.sl = ds.Tables[0].Rows[0]["sl"].ToString();
model.swp = ds.Tables[0].Rows[0]["swp"].ToString();
model.tzz = ds.Tables[0].Rows[0]["tzz"].ToString();
model.wzz = ds.Tables[0].Rows[0]["wzz"].ToString();
model.ysfw = ds.Tables[0].Rows[0]["ysfw"].ToString();
model.z = ds.Tables[0].Rows[0]["z"].ToString();
model.zpz = ds.Tables[0].Rows[0]["zpz"].ToString();
model.jhlx = ds.Tables[0].Rows[0]["jhlx"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ERM.MDL.T_Archive model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Archive set ");
strSql.Append("ajlx='" + model.ajlx + "',");
strSql.Append("ajs='" + model.ajs + "',");
strSql.Append("ajtm='" + model.ajtm + "',");
strSql.Append("ArchiveID='" + model.ArchiveID + "',");
strSql.Append("bgqx='" + model.bgqx + "',");
strSql.Append("bz='" + model.bz + "',");
strSql.Append("bzdw='" + model.bzdw + "',");
strSql.Append("bzrq='" + model.bzrq + "',");
strSql.Append("cdh='" + model.cdh + "',");
strSql.Append("cpz='" + model.cpz + "',");
strSql.Append("dh='" + model.dh + "',");
strSql.Append("dpz='" + model.dpz + "',");
strSql.Append("dtz='" + model.dtz + "',");
strSql.Append("dw='" + model.dw + "',");
strSql.Append("gpz='" + model.gpz + "',");
strSql.Append("ljr='" + model.ljr + "',");
strSql.Append("lxdh='" + model.lxdh + "',");
strSql.Append("lydh='" + model.lydh + "',");
strSql.Append("mj='" + model.mj + "',");
strSql.Append("orderindex=" + model.OrderIndex + ",");
strSql.Append("p='" + model.p + "',");
strSql.Append("ProjectNO='" + model.ProjectNO + "',");
strSql.Append("qt='" + model.qt + "',");
strSql.Append("sl='" + model.sl + "',");
strSql.Append("swp='" + model.swp + "',");
strSql.Append("tzz='" + model.tzz + "',");
strSql.Append("wzz='" + model.wzz + "',");
strSql.Append("ysfw='" + model.ysfw + "',");
strSql.Append("z='" + model.z + "',");
strSql.Append("zpz='" + model.zpz + "',");
strSql.Append("jhlx='" + model.jhlx + "'");
strSql.Append(" where ArchiveID='" + model.ArchiveID + "' ");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.T_Archive model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.ajlx != null)
{
strSql1.Append("ajlx,");
strSql2.Append("'" + model.ajlx + "',");
}
if (model.ajs != null)
{
strSql1.Append("ajs,");
strSql2.Append("'" + model.ajs + "',");
}
if (model.ajtm != null)
{
strSql1.Append("ajtm,");
strSql2.Append("'" + model.ajtm + "',");
}
if (model.ArchiveID != null)
{
strSql1.Append("ArchiveID,");
strSql2.Append("'" + model.ArchiveID + "',");
}
if (model.bgqx != null)
{
strSql1.Append("bgqx,");
strSql2.Append("'" + model.bgqx + "',");
}
if (model.bz != null)
{
strSql1.Append("bz,");
strSql2.Append("'" + model.bz + "',");
}
if (model.bzdw != null)
{
strSql1.Append("bzdw,");
strSql2.Append("'" + model.bzdw + "',");
}
if (model.bzrq != null)
{
strSql1.Append("bzrq,");
strSql2.Append("'" + model.bzrq + "',");
}
if (model.cdh != null)
{
strSql1.Append("cdh,");
strSql2.Append("'" + model.cdh + "',");
}
if (model.cpz != null)
{
strSql1.Append("cpz,");
strSql2.Append("'" + model.cpz + "',");
}
if (model.dh != null)
{
strSql1.Append("dh,");
strSql2.Append("'" + model.dh + "',");
}
if (model.dpz != null)
{
strSql1.Append("dpz,");
strSql2.Append("'" + model.dpz + "',");
}
if (model.dtz != null)
{
strSql1.Append("dtz,");
strSql2.Append("'" + model.dtz + "',");
}
if (model.dw != null)
{
strSql1.Append("dw,");
strSql2.Append("'" + model.dw + "',");
}
if (model.gpz != null)
{
strSql1.Append("gpz,");
strSql2.Append("'" + model.gpz + "',");
}
if (model.ljr != null)
{
strSql1.Append("ljr,");
strSql2.Append("'" + model.ljr + "',");
}
if (model.lxdh != null)
{
strSql1.Append("lxdh,");
strSql2.Append("'" + model.lxdh + "',");
}
if (model.lydh != null)
{
strSql1.Append("lydh,");
strSql2.Append("'" + model.lydh + "',");
}
if (model.mj != null)
{
strSql1.Append("mj,");
strSql2.Append("'" + model.mj + "',");
}
if (model.OrderIndex != null)
{
strSql1.Append("orderindex,");
strSql2.Append("" + model.OrderIndex + ",");
}
if (model.p != null)
{
strSql1.Append("p,");
strSql2.Append("'" + model.p + "',");
}
if (model.ProjectNO != null)
{
strSql1.Append("ProjectNO,");
strSql2.Append("'" + model.ProjectNO + "',");
}
if (model.qt != null)
{
strSql1.Append("qt,");
strSql2.Append("'" + model.qt + "',");
}
if (model.sl != null)
{
strSql1.Append("sl,");
strSql2.Append("'" + model.sl + "',");
}
if (model.swp != null)
{
strSql1.Append("swp,");
strSql2.Append("'" + model.swp + "',");
}
if (model.tzz != null)
{
strSql1.Append("tzz,");
strSql2.Append("'" + model.tzz + "',");
}
if (model.wzz != null)
{
strSql1.Append("wzz,");
strSql2.Append("'" + model.wzz + "',");
}
if (model.ysfw != null)
{
strSql1.Append("ysfw,");
strSql2.Append("'" + model.ysfw + "',");
}
if (model.z != null)
{
strSql1.Append("z,");
strSql2.Append("'" + model.z + "',");
}
if (model.zpz != null)
{
strSql1.Append("zpz,");
strSql2.Append("'" + model.zpz + "',");
}
if (model.jhlx != null)
{
strSql1.Append("jhlx,");
strSql2.Append("'" + model.jhlx + "',");
}
strSql.Append("insert into T_Archive(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
