public List <DeliveryReceiveDetail_Model> GetQualityDetailInfo(DeliveryReceive_Model DeliveryInfo)
{
try
{
string strSql = string.Format("select * from V_GETQUALITYDETAILINFO where receive_id = {0} and voucherno = '{1}' order by rowno asc ", DeliveryInfo.ID, DeliveryInfo.VoucherNo);
List <DeliveryReceiveDetail_Model> lstDeliveryDetailInfo = new List <DeliveryReceiveDetail_Model>();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
DeliveryReceiveDetail_Model DRM = new DeliveryReceiveDetail_Model();
DRM.ID = dr["ID"].ToInt32();
DRM.RowNo = dr["RowNo"].ToDBString();
DRM.MaterialNo = dr["MaterialNo"].ToDBString();
DRM.MaterialDesc = dr["MaterialDesc"].ToDBString();
DRM.ReceiveQty = (decimal)dr["ReceiveQty"];
DRM.Unit = dr["Unit"].ToDBString();
DRM.PrdVersion = dr["PrdVersion"].ToDBString();
DRM.QualityQty = (decimal)dr["QualityQty"];
DRM.UnQualityQty = (decimal)dr["UnQualityQty"];
DRM.VoucherNo = dr["VoucherNo"].ToDBString();
DRM.QualityType = dr["qualitytype"].ToDBString();//string.Empty;//Common_Func.GetComboBoxItem(Common_Func.GetParentMenuByMenu);
lstDeliveryDetailInfo.Add(DRM);
}
}
return(lstDeliveryDetailInfo);
}
catch (Exception ex)
{
throw ex;
}
}
private string GetFilterSql(DeliveryReceiveDetail_Model model, UserInfo user)
{
try
{
string strSql = "";
bool hadWhere = false;
if (model.ID >= 1)
{
strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
strSql += " receive_id = " + model.ID + " ";
hadWhere = true;
}
if (!string.IsNullOrEmpty(model.VoucherNo))
{
strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
strSql += " VoucherNo = '" + model.VoucherNo + "' ";
hadWhere = true;
}
return(strSql);
}
catch
{
return(string.Empty);
}
}
private void GetQueryDetails()
{
if (queryDetails == null)
{
queryDetails = new DeliveryReceiveDetail_Model();
}
queryDetails.ID = lstMain[dgvList.CurrentCell.RowIndex].ID;
queryDetails.VoucherNo = lstMain[dgvList.CurrentCell.RowIndex].VoucherNo;
}
private void dgvList_DataError(object sender, DataGridViewDataErrorEventArgs e)
{
DeliveryReceiveDetail_Model row = bindListDeliveryDetails[e.RowIndex];
if (!string.IsNullOrEmpty(row.QualityType))
{
dgvList[colQualityType.Name, e.RowIndex].Value = row.QualityType.ToInt32();
}
}
private List <DeliveryReceiveDetail_Model> CreateProductionDetails(ref DeliveryReceive_Model ProductionModel, IRfcTable rtb)
{
List <DeliveryReceiveDetail_Model> lstPrdReturnDetails = null;
if (rtb != null)
{
if (rtb.RowCount > 0)
{
lstPrdReturnDetails = new List <DeliveryReceiveDetail_Model>();
}
foreach (var itemRtb in rtb)
{
ProductionModel.Plant = itemRtb.GetString("WERKS");
ProductionModel.PlantName = itemRtb.GetString("NAME1");
ProductionModel.MoveType = string.Empty;
DeliveryReceiveDetail_Model item = new DeliveryReceiveDetail_Model();
item.DeliveryNo = itemRtb.GetString("AUFNR").TrimStart('0');
item.CreateTime = string.Empty;
item.RowNo = string.Empty;
item.VoucherNo = itemRtb.GetString("AUFNR").TrimStart('0');
item.MaterialNo = itemRtb.GetString("MATNR");
item.MaterialDesc = itemRtb.GetString("MAKTX");
item.ClaimArriveTime = string.Empty;
item.Unit = string.Empty;
item.CurrentlyDeliveryNum = itemRtb.GetInt("GAMNG");
item.ClaimDeliveryNum = 0;
item.ReadyDeliveryNum = 0;
item.WaitDeliveryNum = 0;
item.InRoadDeliveryNum = 0;
item.ReceiveTime = string.Empty;
item.DeliveryAddress = string.Empty;
item.CorrespondDepartment = string.Empty;
item.WorkCode = string.Empty;
item.JingxinName = string.Empty;
item.Plant = itemRtb.GetString("WERKS");
item.PlantName = itemRtb.GetString("NAME1");
item.PrdVersion = string.Empty;
item.ReceiveQty = 0;
item.IsUrgent = 1;
item.PackCount = 0;
item.StorageLoc = string.Empty;
item.PrdReturnReason = string.Empty;
item.Barcode = string.Empty;
item.SerialNo = string.Empty;
item.ReserveNumber = string.Empty;
item.ReserveRowNo = string.Empty;
item.OldReceiveQty = itemRtb.GetInt("WEMNG");
item.TrackNo = string.Empty;
lstPrdReturnDetails.Add(item);
}
}
return(lstPrdReturnDetails);
}
private DeliveryReceiveDetail_Model GetDeliveryReceiveDetail_ModelFromDataReader(SqlDataReader dr)
{
DeliveryReceiveDetail_Model model = new DeliveryReceiveDetail_Model();
model.ID = dr["ID"].ToInt32();
model.RowNo = dr["RowNo"].ToDBString();
model.MaterialNo = dr["MaterialNo"].ToDBString();
model.MaterialDesc = dr["MaterialDesc"].ToDBString();
model.ReceiveQty = dr["ReceiveQty"].ToDecimal();
model.Unit = dr["Unit"].ToDBString();
model.PrdVersion = dr["PrdVersion"].ToDBString();
model.QualityQty = dr["QualityQty"].ToDecimal();
model.UnQualityQty = dr["UnQualityQty"].ToDecimal();
model.VoucherNo = dr["VoucherNo"].ToDBString();
model.QualityType = string.Empty;
return(model);
}
/// <summary>
/// 获取已经收货数量
/// </summary>
/// <param name="strPrdVoucherNo"></param>
/// <returns></returns>
public DeliveryReceiveDetail_Model GetProductionOldReceiveQty(string strPrdVoucherNo)
{
try
{
string strSql = string.Format("select deliveryqty , sum(receiveqty) as oldreceiveqty from t_receive a left join t_receivedetails b on a.id = b.receive_id where a.deliveryno ='{0}' group by deliveryqty", strPrdVoucherNo);
DeliveryReceiveDetail_Model DRDM = new DeliveryReceiveDetail_Model();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
if (dr.Read())
{
DRDM.CurrentlyDeliveryNum = dr["deliveryqty"].ToInt32();
DRDM.OldReceiveQty = dr["oldreceiveqty"].ToInt32();
}
}
return(DRDM);
}
catch (Exception ex)
{
throw ex;
}
}
public DeliveryReceive_Model GetTaskInfoByID(string strTaskID, UserInfo userModel)
{
try
{
DeliveryReceive_Model deliveryModel = new DeliveryReceive_Model();
deliveryModel.lstDeliveryDetail = new List <DeliveryReceiveDetail_Model>();
string strSql = string.Format("select * from v_gettaskinfobyid where id = '{0}' and operatoruserno = '{1}'", strTaskID, userModel.UserNo);
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
deliveryModel.ID = dr["id"].ToInt32();
deliveryModel.VoucherType = dr["VoucherType"].ToInt32();
deliveryModel.IsShelvePost = dr["IsShelvePost"].ToInt32();
deliveryModel.VoucherNo = dr["taskno"].ToDBString();
deliveryModel.DeliveryNo = dr["deliveryno"].ToDBString();
deliveryModel.MaterialDoc = dr["MaterialDoc"].ToDBString();
deliveryModel.DocDate = dr["docdate"].ToDateTimeNull();
deliveryModel.MoveType = dr["movetype"].ToDBString();
DeliveryReceiveDetail_Model deliveryDetailModel = new DeliveryReceiveDetail_Model();
deliveryDetailModel.ID = dr["taskdetailid"].ToInt32();
deliveryDetailModel.Plant = dr["plant"].ToDBString();
deliveryDetailModel.MaterialNo = dr["materialno"].ToDBString();
deliveryDetailModel.CurrentPostQty = dr["currentpostqty"].ToDecimal();
deliveryDetailModel.VoucherNo = dr["VoucherNo"].ToDBString();
deliveryDetailModel.RowNo = dr["RowNo"].ToDBString();
deliveryDetailModel.ReserveNumber = dr["ReserveNumber"].ToDBString();
deliveryDetailModel.TrackNo = dr["trackno"].ToDBString();
deliveryDetailModel.ReserveRowNo = dr["ReserveRowNo"].ToDBString();
deliveryModel.lstDeliveryDetail.Add(deliveryDetailModel);
}
}
return(deliveryModel);
}
catch (Exception ex)
{
throw new Exception(ex.Message + ex.TargetSite);
}
}
private List <DeliveryReceiveDetail_Model> CreateDetail(IRfcTable rtb)
{
List <DeliveryReceiveDetail_Model> lstDeliveryDetail = new List <DeliveryReceiveDetail_Model>();
if (rtb != null && rtb.Count > 0)
{
foreach (var itemRtb in rtb)
{
DeliveryReceiveDetail_Model DDM = new DeliveryReceiveDetail_Model();
DDM.VoucherNo = itemRtb.GetString("EBELN");
DDM.RowNo = itemRtb.GetString("EBELP");
DDM.MaterialNo = itemRtb.GetString("MATNR");
DDM.MaterialDesc = itemRtb.GetString("TXZ01");
DDM.CurrentlyDeliveryNum = itemRtb.GetInt("MENGE");
DDM.Plant = itemRtb.GetString("WERKS");
DDM.PlantName = itemRtb.GetString("NAME1");
DDM.StorageLoc = itemRtb.GetString("LGORT");
lstDeliveryDetail.Add(DDM);
}
}
return(lstDeliveryDetail);
}
private List <DeliveryReceiveDetail_Model> CreateProductionReturnDetails(ref DeliveryReceive_Model PrdReturnModel, IRfcTable rtb)
{
List <DeliveryReceiveDetail_Model> lstPrdReturnDetails = null;
if (rtb != null)
{
if (rtb.RowCount > 0)
{
lstPrdReturnDetails = new List <DeliveryReceiveDetail_Model>();
}
foreach (var itemRtb in rtb)
{
PrdReturnModel.Plant = itemRtb.GetString("WERKS");
PrdReturnModel.MoveType = itemRtb.GetString("BWART");
DeliveryReceiveDetail_Model item = new DeliveryReceiveDetail_Model();
item.DeliveryNo = itemRtb.GetString("BEDNR");
item.CreateTime = string.Empty;
item.RowNo = itemRtb.GetString("BSPOS");
item.TrackNo = itemRtb.GetString("AUFNR");
item.VoucherNo = itemRtb.GetString("BEDNR");
item.MaterialNo = itemRtb.GetString("MATNR");
item.MaterialDesc = itemRtb.GetString("MAKTX");
item.ClaimArriveTime = string.Empty;
item.Unit = string.Empty;
item.CurrentlyDeliveryNum = itemRtb.GetInt("MENGE");
item.ClaimDeliveryNum = 0;
item.ReadyDeliveryNum = 0;
item.WaitDeliveryNum = 0;
item.InRoadDeliveryNum = 0;
item.ReceiveTime = string.Empty;
item.DeliveryAddress = string.Empty;
item.CorrespondDepartment = itemRtb.GetString("DEPARTMENT");
item.WorkCode = string.Empty;
item.JingxinName = string.Empty;
item.Plant = itemRtb.GetString("WERKS");
item.PlantName = string.Empty;
item.PrdVersion = string.Empty;
item.ReceiveQty = itemRtb.GetInt("MENGE");
item.IsUrgent = 1;
item.PackCount = 0;
item.StorageLoc = itemRtb.GetString("LGORT");
item.PrdReturnReason = itemRtb.GetString("PMTXT");
item.Barcode = string.Empty;
item.SerialNo = string.Empty;
item.ReserveNumber = itemRtb.GetString("RSNUM");
item.ReserveRowNo = itemRtb.GetString("RSPOS");
if (!string.IsNullOrEmpty(item.TrackNo))
{
item.TrackNo = item.TrackNo.TrimStart('0');
}
if (Common.Common_Func.IsAllZero(item.ReserveNumber))
{
item.ReserveNumber = string.Empty;
}
if (Common.Common_Func.IsAllZero(item.ReserveRowNo))
{
item.ReserveRowNo = string.Empty;
}
lstPrdReturnDetails.Add(item);
}
}
return(lstPrdReturnDetails);
}
public bool GetQualityDetailListByPage(ref List <DeliveryReceiveDetail_Model> modelList, DeliveryReceiveDetail_Model model, ref DividPage page, UserInfo user, ref string strError)
{
if (page == null)
{
page = new DividPage();
}
List <DeliveryReceiveDetail_Model> lstModel = new List <DeliveryReceiveDetail_Model>();
try
{
using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_GETQUALITYDETAILINFO", GetFilterSql(model, user), "*", "Order By rowno Asc"))
{
while (dr.Read())
{
lstModel.Add(GetDeliveryReceiveDetail_ModelFromDataReader(dr));
}
}
modelList = lstModel;
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
finally
{
}
}
public static bool GetCensorshipDetailByPage(ref List <DeliveryReceiveDetail_Model> lstDetail, DeliveryReceiveDetail_Model queryDetail, ref DividPage page, ref string strError)
{
return(WMSWebService.service.GetQualityDetailListByPage(ref lstDetail, queryDetail, ref page, Common_Var.CurrentUser, ref strError));
}
