/// <summary>
/// 得到一个对象实体
/// </summary>
public T_Remittance GetModel(string strOrderCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(sql);
strSql.Append(" and NID=@NID");
SqlParameter[] parameters =
{
new SqlParameter("@NID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = strOrderCode;
T_Remittance model = new T_Remittance();
using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters))
{
if (dr.Read())
{
model.NID = dr["NID"].ToString();
model.RemittanceUse = dr["RemittanceUse"].ToString();
model.SystemDate = dr["SystemDate"].ToString();
model.SystemuserCode = dr["SystemuserCode"].ToString();
model.OrderCodeDate = dr["OrderCodeDate"].ToString();
model.Accessories = dr["Accessories"].ToString();
model.NOTE1 = dr["NOTE1"].ToString();
model.NOTE2 = dr["NOTE2"].ToString();
model.NOTE3 = dr["NOTE3"].ToString();
model.NOTE4 = dr["NOTE4"].ToString();
model.NOTE5 = dr["NOTE5"].ToString();
model.NOTE6 = dr["NOTE6"].ToString();
model.PaymentDeptName = dr["PaymentDeptName"].ToString();
model.NOTE7 = dr["NOTE7"].ToString();
model.NOTE8 = dr["NOTE8"].ToString();
model.NOTE9 = dr["NOTE9"].ToString();
model.NOTE0 = dr["NOTE0"].ToString();
model.PaymentDeptCode = dr["PaymentDeptCode"].ToString();
model.OrderCode = dr["OrderCode"].ToString();
model.TruckCode = dr["TruckCode"].ToString();
model.RemittanceNumber = dr["RemittanceNumber"].ToString();
model.RemittanceDate = dr["RemittanceDate"].ToString();
model.RemittanceType = dr["RemittanceType"].ToString();
if (!DBNull.Value.Equals(dr["RemittanceMoney"]))
{
model.RemittanceMoney = decimal.Parse(dr["RemittanceMoney"].ToString());
}
return(model);
}
else
{
return(null);
}
}
}
public DataTable GetAllListBySql1(T_Remittance model)
{
StringBuilder strSql = new StringBuilder();
List <object> objParams = new List <object>();
strSql.Append(@"select a.billCode,a.billName,a.stepID,a.billDate,a.billDept,a.billJe,(select '['+deptCode+']'+ deptName from bill_departments where deptCode=a.billDept ) as deptName
from bill_main a where a.flowid='cksj'");
// strSql.Append(@"select a.billCode,a.billName,a.stepID,a.billDate,a.billJe,b.*,'['+b.PaymentDeptCode+']'+b.PaymentDeptName as deptnames from
// bill_main a ,T_Remittance b where 1=1 and b.NID=a.billCode");
//订单号
if (model.OrderCode != null && model.OrderCode != "")
{
strSql.Append(" and a.billCode like'%" + model.OrderCode + "%'");
}
//申请日期始
if (model.RemittanceDate != null && model.RemittanceDate != "")
{
strSql.Append(" and a.billDate>='" + model.RemittanceDate + "'");
}
//申请日期末
if (model.NOTE1 != null && model.NOTE1 != "")
{
strSql.Append(" and a.billDate<='" + model.NOTE1 + "'");
}
//TruckCode车架号
if (model.TruckCode != null && model.TruckCode != "")
{
strSql.Append(" and a.billCode in (select NID from T_Remittance where TruckCode like'%" + model.TruckCode + "%')");
}
// 缴款单位
if (model.PaymentDeptCode != null && model.PaymentDeptCode != "")
{
strSql.Append(" and billDept='" + model.PaymentDeptCode + "'");
}
////回款形式
//if (model.RemittanceType != null && model.RemittanceType != "")
//{
// strSql.Append(" and RemittanceType like'%" + model.RemittanceType + "%'");
//}
////审批状态
strSql.Append(" order by a.billDate desc");
return(DataHelper.GetDataTable(strSql.ToString(), null, false));
}
public int Add(T_Remittance model)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
int row = Add(model, tran);
tran.Commit();
return(row);
}
catch
{
tran.Rollback();
throw;
}
}
}
public IList <T_Remittance> ListMaker(string tempsql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(tempsql, sps, false);
IList <T_Remittance> list = new List <T_Remittance>();
foreach (DataRow dr in dt.Rows)
{
T_Remittance model = new T_Remittance();
model.NID = dr["NID"].ToString();
model.RemittanceUse = dr["RemittanceUse"].ToString();
model.SystemDate = dr["SystemDate"].ToString();
model.SystemuserCode = dr["SystemuserCode"].ToString();
model.OrderCodeDate = dr["OrderCodeDate"].ToString();
model.Accessories = dr["Accessories"].ToString();
model.NOTE1 = dr["NOTE1"].ToString();
model.NOTE2 = dr["NOTE2"].ToString();
model.NOTE3 = dr["NOTE3"].ToString();
model.NOTE4 = dr["NOTE4"].ToString();
model.NOTE5 = dr["NOTE5"].ToString();
model.NOTE6 = dr["NOTE6"].ToString();
model.PaymentDeptName = dr["PaymentDeptName"].ToString();
model.NOTE7 = dr["NOTE7"].ToString();
model.NOTE8 = dr["NOTE8"].ToString();
model.NOTE9 = dr["NOTE9"].ToString();
model.NOTE0 = dr["NOTE0"].ToString();
model.PaymentDeptCode = dr["PaymentDeptCode"].ToString();
model.OrderCode = dr["OrderCode"].ToString();
model.TruckCode = dr["TruckCode"].ToString();
model.RemittanceNumber = dr["RemittanceNumber"].ToString();
model.RemittanceDate = dr["RemittanceDate"].ToString();
model.RemittanceType = dr["RemittanceType"].ToString();
if (!DBNull.Value.Equals(dr["RemittanceMoney"]))
{
model.RemittanceMoney = decimal.Parse(dr["RemittanceMoney"].ToString());
}
list.Add(model);
}
return(list);
}
public DataTable GetAllListBySql1(T_Remittance model)
{
return(remitdal.GetAllListBySql1(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(T_Remittance model, SqlTransaction tran)
{
//Delete(model.NID, tran);
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Remittance(");
strSql.Append("RemittanceUse,SystemDate,SystemuserCode,OrderCodeDate,Accessories,NOTE1,NOTE2,NOTE3,NOTE4,NOTE5,NOTE6,PaymentDeptName,NOTE7,NOTE8,NOTE9,NOTE0,PaymentDeptCode,OrderCode,TruckCode,RemittanceNumber,RemittanceDate,RemittanceType,RemittanceMoney,NID");
strSql.Append(") values (");
strSql.Append("@RemittanceUse,@SystemDate,@SystemuserCode,@OrderCodeDate,@Accessories,@NOTE1,@NOTE2,@NOTE3,@NOTE4,@NOTE5,@NOTE6,@PaymentDeptName,@NOTE7,@NOTE8,@NOTE9,@NOTE0,@PaymentDeptCode,@OrderCode,@TruckCode,@RemittanceNumber,@RemittanceDate,@RemittanceType,@RemittanceMoney,@NID");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@RemittanceUse", SqlDbType.NVarChar, 50),
new SqlParameter("@SystemDate", SqlDbType.NVarChar, 50),
new SqlParameter("@SystemuserCode", SqlDbType.NVarChar, 50),
new SqlParameter("@OrderCodeDate", SqlDbType.NVarChar, 50),
new SqlParameter("@Accessories", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE1", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE2", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE3", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE4", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE5", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE6", SqlDbType.NVarChar, 50),
new SqlParameter("@PaymentDeptName", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE7", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE8", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE9", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE0", SqlDbType.NVarChar, 50),
new SqlParameter("@PaymentDeptCode", SqlDbType.NVarChar, 50),
new SqlParameter("@OrderCode", SqlDbType.NVarChar, 50),
new SqlParameter("@TruckCode", SqlDbType.NVarChar, 50),
new SqlParameter("@RemittanceNumber", SqlDbType.NVarChar, 50),
new SqlParameter("@RemittanceDate", SqlDbType.NVarChar, 50),
new SqlParameter("@RemittanceType", SqlDbType.NVarChar, 50),
new SqlParameter("@RemittanceMoney", SqlDbType.Decimal, 9),
new SqlParameter("@NID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = SqlNull(model.RemittanceUse);
parameters[1].Value = SqlNull(model.SystemDate);
parameters[2].Value = SqlNull(model.SystemuserCode);
parameters[3].Value = SqlNull(model.OrderCodeDate);
parameters[4].Value = SqlNull(model.Accessories);
parameters[5].Value = SqlNull(model.NOTE1);
parameters[6].Value = SqlNull(model.NOTE2);
parameters[7].Value = SqlNull(model.NOTE3);
parameters[8].Value = SqlNull(model.NOTE4);
parameters[9].Value = SqlNull(model.NOTE5);
parameters[10].Value = SqlNull(model.NOTE6);
parameters[11].Value = SqlNull(model.PaymentDeptName);
parameters[12].Value = SqlNull(model.NOTE7);
parameters[13].Value = SqlNull(model.NOTE8);
parameters[14].Value = SqlNull(model.NOTE9);
parameters[15].Value = SqlNull(model.NOTE0);
parameters[16].Value = SqlNull(model.PaymentDeptCode);
parameters[17].Value = SqlNull(model.OrderCode);
parameters[18].Value = SqlNull(model.TruckCode);
parameters[19].Value = SqlNull(model.RemittanceNumber);
parameters[20].Value = SqlNull(model.RemittanceDate);
parameters[21].Value = SqlNull(model.RemittanceType);
parameters[22].Value = SqlNull(model.RemittanceMoney);
parameters[23].Value = SqlNull(model.NID);
return(DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false));
}
