public IList <T_TruckTypeCorrespond> ListMaker(string tempsql, SqlParameter[] sps) { DataTable dt = DataHelper.GetDataTable(tempsql, sps, false); IList <T_TruckTypeCorrespond> list = new List <T_TruckTypeCorrespond>(); foreach (DataRow dr in dt.Rows) { T_TruckTypeCorrespond model = new T_TruckTypeCorrespond(); if (!DBNull.Value.Equals(dr["list_id"])) { model.list_id = long.Parse(dr["list_id"].ToString()); } model.Note7 = dr["Note7"].ToString(); model.Note8 = dr["Note8"].ToString(); model.Note9 = dr["Note9"].ToString(); model.Note10 = dr["Note10"].ToString(); model.truckTypeCode = dr["truckTypeCode"].ToString(); model.factTruckType = dr["factTruckType"].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(); list.Add(model); } return(list); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(T_TruckTypeCorrespond model, SqlTransaction tran) { Delete(model.list_id, tran); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_TruckTypeCorrespond("); strSql.Append("Note7,Note8,Note9,Note10,truckTypeCode,factTruckType,Note1,Note2,Note3,Note4,Note5,Note6"); strSql.Append(") values ("); strSql.Append("@Note7,@Note8,@Note9,@Note10,@truckTypeCode,@factTruckType,@Note1,@Note2,@Note3,@Note4,@Note5,@Note6"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@Note7", SqlDbType.NVarChar, 50), new SqlParameter("@Note8", SqlDbType.NVarChar, 50), new SqlParameter("@Note9", SqlDbType.NVarChar, 50), new SqlParameter("@Note10", SqlDbType.NVarChar, 50), new SqlParameter("@truckTypeCode", SqlDbType.NVarChar, 200), new SqlParameter("@factTruckType", SqlDbType.NVarChar, 200), 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) }; parameters[0].Value = SqlNull(model.Note7); parameters[1].Value = SqlNull(model.Note8); parameters[2].Value = SqlNull(model.Note9); parameters[3].Value = SqlNull(model.Note10); parameters[4].Value = SqlNull(model.truckTypeCode); parameters[5].Value = SqlNull(model.factTruckType); parameters[6].Value = SqlNull(model.Note1); parameters[7].Value = SqlNull(model.Note2); parameters[8].Value = SqlNull(model.Note3); parameters[9].Value = SqlNull(model.Note4); parameters[10].Value = SqlNull(model.Note5); parameters[11].Value = SqlNull(model.Note6); return(DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false)); }
public int Add(T_TruckTypeCorrespond model, out string strMsg) { try { strMsg = ""; return(Dal.Add(model)); } catch (Exception ex) { strMsg = ex.Message; throw; } }
/// <summary> /// 得到一个对象实体 /// </summary> public T_TruckTypeCorrespond GetModel(long list_id) { StringBuilder strSql = new StringBuilder(); strSql.Append(sql); strSql.Append(" where list_id=@list_id"); SqlParameter[] parameters = { new SqlParameter("@list_id", SqlDbType.BigInt) }; parameters[0].Value = list_id; T_TruckTypeCorrespond model = new T_TruckTypeCorrespond(); using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters)) { if (dr.Read()) { if (!DBNull.Value.Equals(dr["list_id"])) { model.list_id = long.Parse(dr["list_id"].ToString()); } model.Note7 = dr["Note7"].ToString(); model.Note8 = dr["Note8"].ToString(); model.Note9 = dr["Note9"].ToString(); model.Note10 = dr["Note10"].ToString(); model.truckTypeCode = dr["truckTypeCode"].ToString(); model.factTruckType = dr["factTruckType"].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(); return(model); } else { return(null); } } }
public int Add(T_TruckTypeCorrespond 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 DataTable GetAlltable(T_TruckTypeCorrespond model) { StringBuilder sbQuery = new StringBuilder(); List <SqlParameter> lstParams = new List <SqlParameter>(); string strsql = @"select a.*,(select '['+typeCode+']'+typeName from dbo.T_truckType where typeCode=a.truckTypeCode )as truckTypeName from T_TruckTypeCorrespond a where 1=1"; if (model.truckTypeCode != null && model.truckTypeCode.Trim() != "") { sbQuery.Append(" and a.truckTypeCode in(select typeCode from T_truckType where parentCode='" + model.truckTypeCode + " ')"); sbQuery.Append(" or a.truckTypeCode ='" + model.truckTypeCode + "'"); } //显示所有未对应的记录 if (model.IsShowNoCorrespond != "" && model.IsShowNoCorrespond != null) { sbQuery.Append(" and isnull(truckTypeCode,'')=''"); } strsql += sbQuery.ToString(); return(DataHelper.GetDataTable(strsql, null, false)); }
/// <summary> /// /// </summary> /// <param name="model"></param> /// <returns></returns> public DataTable getalltable(T_TruckTypeCorrespond model) { return(Dal.GetAlltable(model)); }