/// <summary>
///DAL方法：DataTable到IEnumerable<T_HR_LDHTXX> 的转换------>请传入DataTable类型数据，返回IEnumerable<T_HR_LDHTXX>类型对象
/// </summary>
/// <returns></returns>
private IEnumerable <T_HR_LDHTXX> DataTableToList(DataTable dt)
{
List <T_HR_LDHTXX> list = new List <T_HR_LDHTXX>();
foreach (DataRow dr in dt.Rows)
{
T_HR_LDHTXX model = new T_HR_LDHTXX();
model.HT_ID = (dr["HT_ID"] == DBNull.Value) ? null : (string)dr["HT_ID"];
model.RID = (dr["RID"] == DBNull.Value) ? null : (string)dr["RID"];
model.HTBH = (dr["HTBH"] == DBNull.Value) ? null : (string)dr["HTBH"];
model.HTLX = (dr["HTLX"] == DBNull.Value) ? null : (string)dr["HTLX"];
model.KSRQ = (dr["KSRQ"] == DBNull.Value) ? null : (DateTime?)dr["KSRQ"];
model.DQRQ = (dr["DQRQ"] == DBNull.Value) ? null : (DateTime?)dr["DQRQ"];
model.DASZD = (dr["DASZD"] == DBNull.Value) ? null : (string)dr["DASZD"];
model.LDSC = (dr["LDSC"] == DBNull.Value) ? null : (string)dr["LDSC"];
model.BLLYSXRQ = (dr["BLLYSXRQ"] == DBNull.Value) ? null : (DateTime?)dr["BLLYSXRQ"];
model.BLBXRQ = (dr["BLBXRQ"] == DBNull.Value) ? null : (DateTime?)dr["BLBXRQ"];
model.BLGJJRQ = (dr["BLGJJRQ"] == DBNull.Value) ? null : (DateTime?)dr["BLGJJRQ"];
model.YXBS = (dr["YXBS"] == DBNull.Value) ? null : (string)dr["YXBS"];
model.GXRID = (dr["GXRID"] == DBNull.Value) ? null : (string)dr["GXRID"];
model.GXRXM = (dr["GXRXM"] == DBNull.Value) ? null : (string)dr["GXRXM"];
model.GXLX = (dr["GXLX"] == DBNull.Value) ? null : (string)dr["GXLX"];
model.GXYY = (dr["GXYY"] == DBNull.Value) ? null : (string)dr["GXYY"];
model.GXSJ = (object)dr["GXSJ"];
list.Add(model);
}
return(list);
}
/// <summary>
///DAL方法：分页查找数据库中的数据(首页数据为第1页)Row_Number开窗函数方法------>根据传入的参数分页查找数据,请传入查找排序的具体依据[说明：strAccord为数据库列名，strASCorDESC请填写"ASC"或"DESC"],返回IEnumerable<T_HR_LDHTXX>接口数据
/// </summary>
/// <returns></returns>
public IEnumerable <T_HR_LDHTXX> SelectT_HR_LDHTXXByPageRow_NumberUsingReader(int pageIndex, int pageSize, string strAccord, string strASCorDESC)
{
List <T_HR_LDHTXX> list = new List <T_HR_LDHTXX>();
using (SqlDataReader reader = SqlHelper.ExcuteReader("select * from ( select row_number() over(order by " + strAccord + " " + strASCorDESC + ") as rownum ,* from T_HR_LDHTXX )as tempTable where tempTable.rownum> " + ((pageIndex - 1) * pageSize).ToString() + " and tempTable.rownum<=" + (((pageIndex - 1) * pageSize) + pageSize).ToString() + ""))
{
while (reader.Read())
{
T_HR_LDHTXX model = new T_HR_LDHTXX();
//开窗函数会多出一列，第一列为rownum，所以传入索引1开始
model.HT_ID = reader.IsDBNull(1) ? null : reader.GetString(1);
model.RID = reader.IsDBNull(2) ? null : reader.GetString(2);
model.HTBH = reader.IsDBNull(3) ? null : reader.GetString(3);
model.HTLX = reader.IsDBNull(4) ? null : reader.GetString(4);
model.KSRQ = reader.IsDBNull(5) ? null : (DateTime?)reader.GetDateTime(5);
model.DQRQ = reader.IsDBNull(6) ? null : (DateTime?)reader.GetDateTime(6);
model.DASZD = reader.IsDBNull(7) ? null : reader.GetString(7);
model.LDSC = reader.IsDBNull(8) ? null : reader.GetString(8);
model.BLLYSXRQ = reader.IsDBNull(9) ? null : (DateTime?)reader.GetDateTime(9);
model.BLBXRQ = reader.IsDBNull(10) ? null : (DateTime?)reader.GetDateTime(10);
model.BLGJJRQ = reader.IsDBNull(11) ? null : (DateTime?)reader.GetDateTime(11);
model.YXBS = reader.IsDBNull(12) ? null : reader.GetString(12);
model.GXRID = reader.IsDBNull(13) ? null : reader.GetString(13);
model.GXRXM = reader.IsDBNull(14) ? null : reader.GetString(14);
model.GXLX = reader.IsDBNull(15) ? null : reader.GetString(15);
model.GXYY = reader.IsDBNull(16) ? null : reader.GetString(16);
list.Add(model);
}
}
return(list);
}
/// <summary>
///BLL方法：查找数据库中的一条数据------>根据传入的参数查找数据,请传入数据库的列名以及查找对象的具体依据，返回T_HR_LDHTXX对象类型性数据
/// </summary>
/// <returns></returns>
public T_HR_LDHTXX SelectSingleModelByReader(string strDBColumnName, string strSelId)
{
T_HR_LDHTXXDAL Td = new T_HR_LDHTXXDAL();
T_HR_LDHTXX T = Td.SelectSingleModelByReader(strDBColumnName, strSelId);
return(T);
}
/// <summary>
///DAL方法：分页查找数据库中的数据(首页数据为第1页)not in select top...子查询方法------>根据传入的参数分页查找数据,请传入查找排序的具体依据[例如：select top pageSize * from...where strAccord not in...(select top pageSize strAccord from...)][说明：strAccord为数据库列名，strASCorDESC请填写"ASC"或"DESC"],返回IEnumerable<T_HR_LDHTXX>接口数据
/// </summary>
/// <returns></returns>
public IEnumerable <T_HR_LDHTXX> SelectT_HR_LDHTXXByPageUsingReader(int pageIndex, int pageSize, string strAccord, string strASCorDESC)
{
List <T_HR_LDHTXX> list = new List <T_HR_LDHTXX>();
using (SqlDataReader reader = SqlHelper.ExcuteReader("select top " + pageSize + " * from T_HR_LDHTXX where " + strAccord + " not in (select top " + (pageIndex - 1) * pageSize + " " + strAccord + " from T_HR_LDHTXX order by " + strAccord + " " + strASCorDESC + ") order by " + strAccord + " " + strASCorDESC + ""))
{
while (reader.Read())
{
T_HR_LDHTXX model = new T_HR_LDHTXX();
model.HT_ID = reader.IsDBNull(0) ? null : reader.GetString(0);
model.RID = reader.IsDBNull(1) ? null : reader.GetString(1);
model.HTBH = reader.IsDBNull(2) ? null : reader.GetString(2);
model.HTLX = reader.IsDBNull(3) ? null : reader.GetString(3);
model.KSRQ = reader.IsDBNull(4) ? null : (DateTime?)reader.GetDateTime(4);
model.DQRQ = reader.IsDBNull(5) ? null : (DateTime?)reader.GetDateTime(5);
model.DASZD = reader.IsDBNull(6) ? null : reader.GetString(6);
model.LDSC = reader.IsDBNull(7) ? null : reader.GetString(7);
model.BLLYSXRQ = reader.IsDBNull(8) ? null : (DateTime?)reader.GetDateTime(8);
model.BLBXRQ = reader.IsDBNull(9) ? null : (DateTime?)reader.GetDateTime(9);
model.BLGJJRQ = reader.IsDBNull(10) ? null : (DateTime?)reader.GetDateTime(10);
model.YXBS = reader.IsDBNull(11) ? null : reader.GetString(11);
model.GXRID = reader.IsDBNull(12) ? null : reader.GetString(12);
model.GXRXM = reader.IsDBNull(13) ? null : reader.GetString(13);
model.GXLX = reader.IsDBNull(14) ? null : reader.GetString(14);
model.GXYY = reader.IsDBNull(15) ? null : reader.GetString(15);
list.Add(model);
}
}
return(list);
}
/// <summary>
///DAL方法：查找数据库中的全部数据------>返回IEnumerable<T_HR_LDHTXX>接口数据
/// </summary>
/// <returns></returns>
public IEnumerable <T_HR_LDHTXX> SelectAllByReader()
{
List <T_HR_LDHTXX> list = new List <T_HR_LDHTXX>();
using (SqlDataReader reader = SqlHelper.ExcuteReader("select * from T_HR_LDHTXX"))
{
while (reader.Read())
{
T_HR_LDHTXX model = new T_HR_LDHTXX();
model.HT_ID = reader.IsDBNull(0) ? null : reader.GetString(0);
model.RID = reader.IsDBNull(1) ? null : reader.GetString(1);
model.HTBH = reader.IsDBNull(2) ? null : reader.GetString(2);
model.HTLX = reader.IsDBNull(3) ? null : reader.GetString(3);
model.KSRQ = reader.IsDBNull(4) ? null : (DateTime?)reader.GetDateTime(4);
model.DQRQ = reader.IsDBNull(5) ? null : (DateTime?)reader.GetDateTime(5);
model.DASZD = reader.IsDBNull(6) ? null : reader.GetString(6);
model.LDSC = reader.IsDBNull(7) ? null : reader.GetString(7);
model.BLLYSXRQ = reader.IsDBNull(8) ? null : (DateTime?)reader.GetDateTime(8);
model.BLBXRQ = reader.IsDBNull(9) ? null : (DateTime?)reader.GetDateTime(9);
model.BLGJJRQ = reader.IsDBNull(10) ? null : (DateTime?)reader.GetDateTime(10);
model.YXBS = reader.IsDBNull(11) ? null : reader.GetString(11);
model.GXRID = reader.IsDBNull(12) ? null : reader.GetString(12);
model.GXRXM = reader.IsDBNull(13) ? null : reader.GetString(13);
model.GXLX = reader.IsDBNull(14) ? null : reader.GetString(14);
model.GXYY = reader.IsDBNull(15) ? null : reader.GetString(15);
list.Add(model);
}
}
return(list);
}
/// <summary>
///BLL方法：更新数据库中的一条数据------>根据传入的参数更新数据,请传入数据库的列名以及更新对象的具体依据，返回影响条数
/// </summary>
/// <returns></returns>
public int Update(T_HR_LDHTXX model, string strDBColumnName, string strUpdateId)
{
T_HR_LDHTXXDAL Td = new T_HR_LDHTXXDAL();
int u = Td.Update(model, strDBColumnName, strUpdateId);
return(u);
}
/// <summary>
///BLL方法：向数据库中增加新一条新的T_HR_LDHTXX对象数据------>请传入对象，返回首行首列
/// </summary>
/// <returns></returns>
public object Add(T_HR_LDHTXX model)
{
T_HR_LDHTXXDAL td = new T_HR_LDHTXXDAL();
object a = td.Add(model);
return(a);
}
/// <summary>
///DAL方法：查找数据库中的一条数据------>根据传入的参数查找数据,请传入数据库的列名以及查找对象的具体依据，返回T_HR_LDHTXX对象类型性数据
/// </summary>
/// <returns></returns>
public T_HR_LDHTXX SelectSingleModelByReader(string strDBColumnName, string strSelId)
{
using (SqlDataReader reader = SqlHelper.ExcuteReader("select * from T_HR_LDHTXX where " + strDBColumnName + " = @ID", new SqlParameter("ID", strSelId)))
{
if (reader.HasRows)
{
if (reader.Read())
{
T_HR_LDHTXX model = new T_HR_LDHTXX();
model.HT_ID = reader.IsDBNull(0) ? null : reader.GetString(0);
model.RID = reader.IsDBNull(1) ? null : reader.GetString(1);
model.HTBH = reader.IsDBNull(2) ? null : reader.GetString(2);
model.HTLX = reader.IsDBNull(3) ? null : reader.GetString(3);
model.KSRQ = reader.IsDBNull(4) ? null : (DateTime?)reader.GetDateTime(4);
model.DQRQ = reader.IsDBNull(5) ? null : (DateTime?)reader.GetDateTime(5);
model.DASZD = reader.IsDBNull(6) ? null : reader.GetString(6);
model.LDSC = reader.IsDBNull(7) ? null : reader.GetString(7);
model.BLLYSXRQ = reader.IsDBNull(8) ? null : (DateTime?)reader.GetDateTime(8);
model.BLBXRQ = reader.IsDBNull(9) ? null : (DateTime?)reader.GetDateTime(9);
model.BLGJJRQ = reader.IsDBNull(10) ? null : (DateTime?)reader.GetDateTime(10);
model.YXBS = reader.IsDBNull(11) ? null : reader.GetString(11);
model.GXRID = reader.IsDBNull(12) ? null : reader.GetString(12);
model.GXRXM = reader.IsDBNull(13) ? null : reader.GetString(13);
model.GXLX = reader.IsDBNull(14) ? null : reader.GetString(14);
model.GXYY = reader.IsDBNull(15) ? null : reader.GetString(15);
return(model);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
}
/// <summary>
///DAL方法：查找数据库中的一条数据------>根据传入的参数查找数据,请传入数据库的列名以及查找对象的具体依据，返回T_HR_LDHTXX对象类型性数据
/// </summary>
/// <returns></returns>
public T_HR_LDHTXX SelectSingleModelByAdapter(string strDBColumnName, string strSelId)
{
DataTable dt = SqlHelper.ExecuteDataTable("select * from T_HR_LDHTXX where " + strDBColumnName + " = @ID", new SqlParameter("ID", strSelId));
if (dt.Rows.Count <= 0)
{
return(null);
}
else if (dt.Rows.Count == 1)
{
T_HR_LDHTXX model = new T_HR_LDHTXX();
DataRow dr = dt.Rows[0];
model.HT_ID = (dr["HT_ID"] == DBNull.Value) ? null : (string)dr["HT_ID"];
model.RID = (dr["RID"] == DBNull.Value) ? null : (string)dr["RID"];
model.HTBH = (dr["HTBH"] == DBNull.Value) ? null : (string)dr["HTBH"];
model.HTLX = (dr["HTLX"] == DBNull.Value) ? null : (string)dr["HTLX"];
model.KSRQ = (dr["KSRQ"] == DBNull.Value) ? null : (DateTime?)dr["KSRQ"];
model.DQRQ = (dr["DQRQ"] == DBNull.Value) ? null : (DateTime?)dr["DQRQ"];
model.DASZD = (dr["DASZD"] == DBNull.Value) ? null : (string)dr["DASZD"];
model.LDSC = (dr["LDSC"] == DBNull.Value) ? null : (string)dr["LDSC"];
model.BLLYSXRQ = (dr["BLLYSXRQ"] == DBNull.Value) ? null : (DateTime?)dr["BLLYSXRQ"];
model.BLBXRQ = (dr["BLBXRQ"] == DBNull.Value) ? null : (DateTime?)dr["BLBXRQ"];
model.BLGJJRQ = (dr["BLGJJRQ"] == DBNull.Value) ? null : (DateTime?)dr["BLGJJRQ"];
model.YXBS = (dr["YXBS"] == DBNull.Value) ? null : (string)dr["YXBS"];
model.GXRID = (dr["GXRID"] == DBNull.Value) ? null : (string)dr["GXRID"];
model.GXRXM = (dr["GXRXM"] == DBNull.Value) ? null : (string)dr["GXRXM"];
model.GXLX = (dr["GXLX"] == DBNull.Value) ? null : (string)dr["GXLX"];
model.GXYY = (dr["GXYY"] == DBNull.Value) ? null : (string)dr["GXYY"];
model.GXSJ = (object)dr["GXSJ"];
return(model);
}
else
{
throw new Exception("出现多条数据!");
}
}
/// <summary>
///DAL方法：更新数据库中的一条数据------>根据传入的参数更新数据,请传入数据库的列名以及更新对象的具体依据，返回影响条数
/// </summary>
/// <returns></returns>
public int Update(T_HR_LDHTXX model, string strDBColumnName, string strUpdateId)
{
int e = SqlHelper.ExecuteNonQuery("update T_HR_LDHTXX set HT_ID=@HT_ID,RID=@RID,HTBH=@HTBH,HTLX=@HTLX,KSRQ=@KSRQ,DQRQ=@DQRQ,DASZD=@DASZD,LDSC=@LDSC,BLLYSXRQ=@BLLYSXRQ,BLBXRQ=@BLBXRQ,BLGJJRQ=@BLGJJRQ,YXBS=@YXBS,GXRID=@GXRID,GXRXM=@GXRXM,GXLX=@GXLX,GXYY=@GXYY,GXSJ=@GXSJ where " + strDBColumnName + " = @Id", new SqlParameter("HT_ID", model.HT_ID), new SqlParameter("RID", model.RID), new SqlParameter("HTBH", model.HTBH), new SqlParameter("HTLX", model.HTLX), new SqlParameter("KSRQ", model.KSRQ), new SqlParameter("DQRQ", model.DQRQ), new SqlParameter("DASZD", model.DASZD), new SqlParameter("LDSC", model.LDSC), new SqlParameter("BLLYSXRQ", model.BLLYSXRQ), new SqlParameter("BLBXRQ", model.BLBXRQ), new SqlParameter("BLGJJRQ", model.BLGJJRQ), new SqlParameter("YXBS", model.YXBS), new SqlParameter("GXRID", model.GXRID), new SqlParameter("GXRXM", model.GXRXM), new SqlParameter("GXLX", model.GXLX), new SqlParameter("GXYY", model.GXYY), new SqlParameter("GXSJ", model.GXSJ), new SqlParameter("Id", strUpdateId));
return(e);
}
/// <summary>
///DAL方法：模糊查找数据库中符合条件的全部数据------>返回IEnumerable<T_HR_LDHTXX>接口数据
/// </summary>
/// <returns></returns>
public IEnumerable <T_HR_LDHTXX> FuzzyQueryByReader(bool HT_IDIsChecked, string HT_ID, bool RIDIsChecked, string RID, bool HTBHIsChecked, string HTBH, bool HTLXIsChecked, string HTLX, bool KSRQIsChecked, string KSRQ, bool DQRQIsChecked, string DQRQ, bool DASZDIsChecked, string DASZD, bool LDSCIsChecked, string LDSC, bool BLLYSXRQIsChecked, string BLLYSXRQ, bool BLBXRQIsChecked, string BLBXRQ, bool BLGJJRQIsChecked, string BLGJJRQ, bool YXBSIsChecked, string YXBS, bool GXRIDIsChecked, string GXRID, bool GXRXMIsChecked, string GXRXM, bool GXLXIsChecked, string GXLX, bool GXYYIsChecked, string GXYY, bool GXSJIsChecked, string GXSJ)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from T_HR_LDHTXX");
List <string> list = new List <string>();
List <SqlParameter> listParameter = new List <SqlParameter>();
if (HT_IDIsChecked)
{
list.Add("HT_ID like @HT_ID");
listParameter.Add(new SqlParameter("HT_ID", "%" + HT_ID + "%"));
}
if (RIDIsChecked)
{
list.Add("RID like @RID");
listParameter.Add(new SqlParameter("RID", "%" + RID + "%"));
}
if (HTBHIsChecked)
{
list.Add("HTBH like @HTBH");
listParameter.Add(new SqlParameter("HTBH", "%" + HTBH + "%"));
}
if (HTLXIsChecked)
{
list.Add("HTLX like @HTLX");
listParameter.Add(new SqlParameter("HTLX", "%" + HTLX + "%"));
}
if (KSRQIsChecked)
{
list.Add("KSRQ like @KSRQ");
listParameter.Add(new SqlParameter("KSRQ", "%" + KSRQ + "%"));
}
if (DQRQIsChecked)
{
list.Add("DQRQ like @DQRQ");
listParameter.Add(new SqlParameter("DQRQ", "%" + DQRQ + "%"));
}
if (DASZDIsChecked)
{
list.Add("DASZD like @DASZD");
listParameter.Add(new SqlParameter("DASZD", "%" + DASZD + "%"));
}
if (LDSCIsChecked)
{
list.Add("LDSC like @LDSC");
listParameter.Add(new SqlParameter("LDSC", "%" + LDSC + "%"));
}
if (BLLYSXRQIsChecked)
{
list.Add("BLLYSXRQ like @BLLYSXRQ");
listParameter.Add(new SqlParameter("BLLYSXRQ", "%" + BLLYSXRQ + "%"));
}
if (BLBXRQIsChecked)
{
list.Add("BLBXRQ like @BLBXRQ");
listParameter.Add(new SqlParameter("BLBXRQ", "%" + BLBXRQ + "%"));
}
if (BLGJJRQIsChecked)
{
list.Add("BLGJJRQ like @BLGJJRQ");
listParameter.Add(new SqlParameter("BLGJJRQ", "%" + BLGJJRQ + "%"));
}
if (YXBSIsChecked)
{
list.Add("YXBS like @YXBS");
listParameter.Add(new SqlParameter("YXBS", "%" + YXBS + "%"));
}
if (GXRIDIsChecked)
{
list.Add("GXRID like @GXRID");
listParameter.Add(new SqlParameter("GXRID", "%" + GXRID + "%"));
}
if (GXRXMIsChecked)
{
list.Add("GXRXM like @GXRXM");
listParameter.Add(new SqlParameter("GXRXM", "%" + GXRXM + "%"));
}
if (GXLXIsChecked)
{
list.Add("GXLX like @GXLX");
listParameter.Add(new SqlParameter("GXLX", "%" + GXLX + "%"));
}
if (GXYYIsChecked)
{
list.Add("GXYY like @GXYY");
listParameter.Add(new SqlParameter("GXYY", "%" + GXYY + "%"));
}
if (GXSJIsChecked)
{
list.Add("GXSJ like @GXSJ");
listParameter.Add(new SqlParameter("GXSJ", "%" + GXSJ + "%"));
}
if (list.Count > 0)
{
sb.Append(" where ");
string sql = string.Join(" and ", list.ToArray());
sb.Append(sql);
}
List <T_HR_LDHTXX> listT_HR_LDHTXX = new List <T_HR_LDHTXX>();
using (SqlDataReader reader = SqlHelper.ExcuteReader(sb.ToString(), listParameter.ToArray()))
{
while (reader.Read())
{
T_HR_LDHTXX model = new T_HR_LDHTXX();
model.HT_ID = reader.IsDBNull(0) ? null : reader.GetString(0);
model.RID = reader.IsDBNull(1) ? null : reader.GetString(1);
model.HTBH = reader.IsDBNull(2) ? null : reader.GetString(2);
model.HTLX = reader.IsDBNull(3) ? null : reader.GetString(3);
model.KSRQ = reader.IsDBNull(4) ? null : (DateTime?)reader.GetDateTime(4);
model.DQRQ = reader.IsDBNull(5) ? null : (DateTime?)reader.GetDateTime(5);
model.DASZD = reader.IsDBNull(6) ? null : reader.GetString(6);
model.LDSC = reader.IsDBNull(7) ? null : reader.GetString(7);
model.BLLYSXRQ = reader.IsDBNull(8) ? null : (DateTime?)reader.GetDateTime(8);
model.BLBXRQ = reader.IsDBNull(9) ? null : (DateTime?)reader.GetDateTime(9);
model.BLGJJRQ = reader.IsDBNull(10) ? null : (DateTime?)reader.GetDateTime(10);
model.YXBS = reader.IsDBNull(11) ? null : reader.GetString(11);
model.GXRID = reader.IsDBNull(12) ? null : reader.GetString(12);
model.GXRXM = reader.IsDBNull(13) ? null : reader.GetString(13);
model.GXLX = reader.IsDBNull(14) ? null : reader.GetString(14);
model.GXYY = reader.IsDBNull(15) ? null : reader.GetString(15);
listT_HR_LDHTXX.Add(model);
}
}
return(listT_HR_LDHTXX);
}
/// <summary>
///DAL方法：向数据库中增加一条新的T_HR_LDHTXX对象数据------>请传入对象,返回首行首列
/// </summary>
/// <returns></returns>
public object Add(T_HR_LDHTXX model)
{
object b = SqlHelper.ExecuteScalar("insert into T_HR_LDHTXX (HT_ID,RID,HTBH,HTLX,KSRQ,DQRQ,DASZD,LDSC,BLLYSXRQ,BLBXRQ,BLGJJRQ,YXBS,GXRID,GXRXM,GXLX,GXYY,GXSJ) output inserted.HT_ID values(@HT_ID,@RID,@HTBH,@HTLX,@KSRQ,@DQRQ,@DASZD,@LDSC,@BLLYSXRQ,@BLBXRQ,@BLGJJRQ,@YXBS,@GXRID,@GXRXM,@GXLX,@GXYY,@GXSJ)", new SqlParameter("HT_ID", model.HT_ID), new SqlParameter("RID", model.RID), new SqlParameter("HTBH", model.HTBH), new SqlParameter("HTLX", model.HTLX), new SqlParameter("KSRQ", model.KSRQ), new SqlParameter("DQRQ", model.DQRQ), new SqlParameter("DASZD", model.DASZD), new SqlParameter("LDSC", model.LDSC), new SqlParameter("BLLYSXRQ", model.BLLYSXRQ), new SqlParameter("BLBXRQ", model.BLBXRQ), new SqlParameter("BLGJJRQ", model.BLGJJRQ), new SqlParameter("YXBS", model.YXBS), new SqlParameter("GXRID", model.GXRID), new SqlParameter("GXRXM", model.GXRXM), new SqlParameter("GXLX", model.GXLX), new SqlParameter("GXYY", model.GXYY), new SqlParameter("GXSJ", model.GXSJ));
return(b);
}
