/// <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;
}
}
