/// <summary> ///保存工作,返回明细表基本信息 /// </summary> /// <returns></returns> private List<vBArrangeBillDetailData> SetDetailApplyBillModel() { if (this.DtResult != null) { List<vBArrangeBillDetailData> list = new List<vBArrangeBillDetailData>(); foreach (DataRow dr in this.DtResult.Rows) { vBArrangeBillDetailData model = new vBArrangeBillDetailData(); int detailId = Convert.ToInt32(dr["id"]); //修改行 if (detailId > 0) { using (BArrangeBillDetailBB datailBB = new BArrangeBillDetailBB()) { model = datailBB.GetVModel(detailId); } } if (detailId > 0 && dr["isdel"].ToString() == "1") { //删除 model.arriveBillNo = ""; } else { //新增明细 关联申请单号 model.arriveBillNo = this.ArriveBillNo; } if ((detailId == 0 && dr["isdel"].ToString() == "0") || detailId > 0) { model.arrangeBillNo = dr["arrangeBillNo"].ToString(); model.arriveBillNo = dr["arriveBillNo"].ToString(); model.materialDesc = dr["materialDesc"].ToString(); model.materialNo = dr["materialNo"].ToString(); model.financeBillNo = dr["financeBillNo"].ToString(); model.palletIndex = Convert.ToInt32(dr["palletIndex"]); if (dr["region"].ToString() != "") { model.region = Convert.ToInt32(dr["region"].ToString()); } if (dr["boxNum"].ToString() != "") { model.boxNum = Convert.ToInt32(dr["boxNum"].ToString()); } if (dr["instantState"].ToString() == "" || dr["instantState"].ToString() == "01") { model.instantState = "01"; } list.Add(model); } } return list; } return null; }
/// <summary> /// 得到一个视图model /// </summary> /// <param name="id">主键值</param> /// <returns>model</returns> public vBArrangeBillDetailData GetVModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select id,arrangeBillNo,arriveBillNo,financeBillNo,palletIndex,materialNo,boxNum,region,isrtEmpId,isrtDt,updtEmpId, updtDt,wareSortNo,instantState,materialDesc,consignBoxNum,customNo,financeBillSort,wareSortNm from vBArrangeBillDetail"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; vBArrangeBillDetailData model = new vBArrangeBillDetailData(); DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; if (row["id"] != DBNull.Value) { model.id = Convert.ToInt32(row["id"]); } if (row["arrangeBillNo"] != DBNull.Value) { model.arrangeBillNo = Convert.ToString(row["arrangeBillNo"]); } if (row["arriveBillNo"] != DBNull.Value) { model.arriveBillNo = Convert.ToString(row["arriveBillNo"]); } if (row["financeBillNo"] != DBNull.Value) { model.financeBillNo = Convert.ToString(row["financeBillNo"]); } if (row["palletIndex"] != DBNull.Value) { model.palletIndex = Convert.ToInt32(row["palletIndex"]); } if (row["materialNo"] != DBNull.Value) { model.materialNo = Convert.ToString(row["materialNo"]); } if (row["boxNum"] != DBNull.Value) { model.boxNum = Convert.ToInt32(row["boxNum"]); } if (row["region"] != DBNull.Value) { model.region = Convert.ToInt32(row["region"]); } if (row["isrtEmpId"] != DBNull.Value) { model.isrtEmpId = Convert.ToInt32(row["isrtEmpId"]); } if (row["isrtDt"] != DBNull.Value) { model.isrtDt = Convert.ToString(row["isrtDt"]); } if (row["updtEmpId"] != DBNull.Value) { model.updtEmpId = Convert.ToInt32(row["updtEmpId"]); } if (row["updtDt"] != DBNull.Value) { model.updtDt = Convert.ToString(row["updtDt"]); } if (row["wareSortNo"] != DBNull.Value) { model.wareSortNo = Convert.ToString(row["wareSortNo"]); } if (row["instantState"] != DBNull.Value) { model.instantState = Convert.ToString(row["instantState"]); } if (row["materialDesc"] != DBNull.Value) { model.materialDesc = Convert.ToString(row["materialDesc"]); } if (row["consignBoxNum"] != DBNull.Value) { model.consignBoxNum = Convert.ToInt32(row["consignBoxNum"]); } if (row["customNo"] != DBNull.Value) { model.customNo = Convert.ToString(row["customNo"]); } if (row["financeBillSort"] != DBNull.Value) { model.financeBillSort = Convert.ToString(row["financeBillSort"]); } if (row["wareSortNm"] != DBNull.Value) { model.wareSortNm = Convert.ToString(row["wareSortNm"]); } return model; } else { return null; } }