/// <summary> /// 查询实体 /// </summary> /// <param name="djbm">ModelDjbm 单据编码</param> /// <param name="spxh">ModelSpxh 商品序号</param> /// <returns>ModelDetaildata</returns> public ModelDetaildata DetaildataDetail(out string resultMsg, String djbm, Int32 spxh) { resultMsg = string.Empty; var model = new ModelDetaildata(); try { //存储过程名称 string sql = "USP_DETAILDATA_SELECT_DETAIL_BY_DJBM_SPXH"; //参数添加 IList<DBParameter> parm = new List<DBParameter>(); parm.Add(new DBParameter() { ParameterName = "DJBM", ParameterValue = djbm, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "SPXH", ParameterValue = spxh, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); //查询执行 using (IDataReader dr = DBHelper.ExecuteReader(sql, true, parm)) { IList<ModelDetaildata> list = GetModel(dr); model = list.First(); } } catch (Exception ex) { resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString()); } return model; }
/// <summary> /// 数据 添加/更新 /// </summary> /// <param name="detaildata">实体</param> /// <returns>执行结果</returns> public int DetaildataInsertUpdate(out string resultMsg, ModelDetaildata detaildata, DbTransaction tran = null) { resultMsg = string.Empty; int res = 0; try { //存储过程名称 string sql = "USP_DETAILDATA_INSERT_UPDATE"; //参数添加 IList<DBParameter> parm = new List<DBParameter>(); parm.Add(new DBParameter() { ParameterName = "DJBM", ParameterValue = detaildata.Djbm, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "SPXH", ParameterValue = detaildata.Spxh, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "BAXH", ParameterValue = detaildata.Baxh, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "SPBH", ParameterValue = detaildata.Spbh, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "FJBH", ParameterValue = detaildata.Fjbh, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "SPMC", ParameterValue = detaildata.Spmc, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "GGXH", ParameterValue = detaildata.Ggxh, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "CJSL", ParameterValue = detaildata.Cjsl, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Object }); parm.Add(new DBParameter() { ParameterName = "CJDW", ParameterValue = detaildata.Cjdw, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "CJDJ", ParameterValue = detaildata.Cjdj, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Object }); parm.Add(new DBParameter() { ParameterName = "CJZJ", ParameterValue = detaildata.Cjzj, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Object }); parm.Add(new DBParameter() { ParameterName = "BIZHI", ParameterValue = detaildata.Bizhi, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "FDSL", ParameterValue = detaildata.Fdsl, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Object }); parm.Add(new DBParameter() { ParameterName = "FDDW", ParameterValue = detaildata.Fddw, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "BBH", ParameterValue = detaildata.Bbh, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "HUOH", ParameterValue = detaildata.Huoh, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "SCCJ", ParameterValue = detaildata.Sccj, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "DESL", ParameterValue = detaildata.Desl, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Object }); parm.Add(new DBParameter() { ParameterName = "DEDW", ParameterValue = detaildata.Dedw, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "MDD", ParameterValue = detaildata.Mdd, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "ZM", ParameterValue = detaildata.Zm, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "GJF", ParameterValue = detaildata.Gjf, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Object }); parm.Add(new DBParameter() { ParameterName = "YT", ParameterValue = detaildata.Yt, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "resultMsg", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.String }); //新增/更新执行 res = DBHelper.ExecuteNonQuery(sql, true, parm, tran); foreach (var item in parm) { //获取输出参数值 if (item.ParameterName == "resultMsg") { resultMsg = item.ParameterValue.ToString(); break; } } } catch (Exception ex) { if (tran != null) tran.Rollback(); resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString()); } return res; }
/// <summary> /// Model 赋值 IDataReader /// </summary> private IList<ModelDetaildata> GetModel(IDataReader dr) { var modelList = new List<ModelDetaildata>(); while (dr.Read()) { var model = new ModelDetaildata(); model.Djbm = dr["djbm"] == DBNull.Value ? string.Empty : dr["djbm"].ToString(); model.Spxh = dr["spxh"] == DBNull.Value ? 0 : Convert.ToInt32(dr["spxh"]); model.Baxh = dr["baxh"] == DBNull.Value ? string.Empty : dr["baxh"].ToString(); model.Spbh = dr["spbh"] == DBNull.Value ? string.Empty : dr["spbh"].ToString(); model.Fjbh = dr["fjbh"] == DBNull.Value ? string.Empty : dr["fjbh"].ToString(); model.Spmc = dr["spmc"] == DBNull.Value ? string.Empty : dr["spmc"].ToString(); model.Ggxh = dr["ggxh"] == DBNull.Value ? string.Empty : dr["ggxh"].ToString(); model.Cjsl = dr["cjsl"] == DBNull.Value ? null : (Object)dr["cjsl"]; model.Cjdw = dr["cjdw"] == DBNull.Value ? string.Empty : dr["cjdw"].ToString(); model.Cjdj = dr["cjdj"] == DBNull.Value ? null : (Object)dr["cjdj"]; model.Cjzj = dr["cjzj"] == DBNull.Value ? null : (Object)dr["cjzj"]; model.Bizhi = dr["bizhi"] == DBNull.Value ? string.Empty : dr["bizhi"].ToString(); model.Fdsl = dr["fdsl"] == DBNull.Value ? null : (Object)dr["fdsl"]; model.Fddw = dr["fddw"] == DBNull.Value ? string.Empty : dr["fddw"].ToString(); model.Bbh = dr["bbh"] == DBNull.Value ? string.Empty : dr["bbh"].ToString(); model.Huoh = dr["huoh"] == DBNull.Value ? string.Empty : dr["huoh"].ToString(); model.Sccj = dr["sccj"] == DBNull.Value ? string.Empty : dr["sccj"].ToString(); model.Desl = dr["desl"] == DBNull.Value ? null : (Object)dr["desl"]; model.Dedw = dr["dedw"] == DBNull.Value ? string.Empty : dr["dedw"].ToString(); model.Mdd = dr["mdd"] == DBNull.Value ? string.Empty : dr["mdd"].ToString(); model.Zm = dr["zm"] == DBNull.Value ? string.Empty : dr["zm"].ToString(); model.Gjf = dr["gjf"] == DBNull.Value ? null : (Object)dr["gjf"]; model.Yt = dr["yt"] == DBNull.Value ? string.Empty : dr["yt"].ToString(); modelList.Add(model); } return modelList; }
public int DetaildataInsertUpdate(out string resultMsg, ModelDetaildata detaildata, DbTransaction tran = null) { throw new NotImplementedException(); }