public AttributeInstance SaveAttribute(int windowNoParent, string strLotStringC, string strSerNoC, string dtGuaranteeDateC, string strAttrCodeC,
bool productWindow, int mAttributeSetInstanceId, int mProductId, int windowNo, List <KeyNamePair> values, Ctx ctx)
{
var editors = values;
AttributeInstance obj = new AttributeInstance();
String strLotString = "", strSerNo = "", strAttrCode = "";
int attributeID = 0, prdAttributes = 0, pAttribute_ID = 0, product_id = 0;
StringBuilder sql = new StringBuilder();
string qry = "";
StringBuilder qryAttr = null;
DataSet ds = null;
DateTime? dtGuaranteeDate = null;
bool _changed = false;
if (!productWindow && strLotStringC != null)
{
strLotString = strLotStringC;
} // L
if (!productWindow && strSerNoC != null)
{
log.Fine("SerNo=" + strSerNoC);
strSerNo = strSerNoC;
}
if (!productWindow && dtGuaranteeDateC != null)
{
dtGuaranteeDate = Convert.ToDateTime(dtGuaranteeDateC);
} // Gua
if (!productWindow && strAttrCodeC != null)
{
strAttrCode = strAttrCodeC;
}
if (String.IsNullOrEmpty(strAttrCode))
{
ctx.SetContext(windowNoParent, "AttrCode", "");
}
else
{
ctx.SetContext(windowNoParent, "AttrCode", strAttrCode);
}
MAttributeSet aset = null;
MAttribute[] attributes = null;
String mandatory = "";
var _masi = MAttributeSetInstance.Get(ctx, 0, mProductId);
aset = _masi.GetMAttributeSet();
if (aset == null)
{
return(null);
}
if (!productWindow && strAttrCode != "")
{
qryAttr = new StringBuilder();
qryAttr.Append(@"SELECT count(*) FROM M_Product prd LEFT JOIN M_ProductAttributes patr on (prd.M_Product_ID=patr.M_Product_ID) " +
" LEFT JOIN M_Manufacturer muf on (prd.M_Product_ID=muf.M_Product_ID) WHERE (patr.UPC = '" + strAttrCode + "' OR prd.UPC = '" + strAttrCode + "' OR muf.UPC = '" + strAttrCode + "')");
//"AND (patr.M_Product_ID = " + _M_Product_ID + " OR prd.M_Product_ID = " + _M_Product_ID + " OR muf.M_Product_ID = " + _M_Product_ID + ")";
prdAttributes = Util.GetValueOfInt(DB.ExecuteScalar(qryAttr.ToString()));
if (prdAttributes != 0)
{
//qryAttr.Clear();
//qryAttr.Append("SELECT M_AttributeSetInstance_ID FROM M_ProductAttributes WHERE UPC = '" + strAttrCode + "' AND M_Product_ID = " + _M_Product_ID);
//attributeID = Util.GetValueOfInt(DB.ExecuteScalar(qryAttr.ToString()));
//if (attributeID == 0)
//{
qryAttr.Clear();
qryAttr.Append("SELECT M_ProductAttributes_ID FROM M_ProductAttributes WHERE UPC = '" + strAttrCode + "'");
pAttribute_ID = Util.GetValueOfInt(DB.ExecuteScalar(qryAttr.ToString()));
if (pAttribute_ID != 0)
{
MProductAttributes patr = new MProductAttributes(ctx, pAttribute_ID, null);
attributeID = patr.GetM_AttributeSetInstance_ID();
product_id = patr.GetM_Product_ID();
}
//}
}
_changed = true;
} // Attribute Code
if (!productWindow && aset.IsLot())
{
log.Fine("Lot=" + strLotString);
String text = strLotString;
_masi.SetLot(text);
sql.Append("UPPER(ats.Lot) = '" + text.ToUpper() + "'");
if (aset.IsLotMandatory() && (text == null || text.Length == 0))
{
mandatory += " - " + Msg.Translate(ctx, "Lot");
}
_changed = true;
} // Lot
if (!productWindow && aset.IsSerNo())
{
log.Fine("SerNo=" + strSerNo);
String text = strSerNo;
_masi.SetSerNo(text);
_masi.SetSerNo(text);
if (sql.Length > 0)
{
sql.Append(" and UPPER(ats.SerNo) = '" + text.ToUpper() + "'");
}
else
{
sql.Append(" UPPER(ats.SerNo) = '" + text.ToUpper() + "'");
}
if (aset.IsSerNoMandatory() && (text == null || text.Length == 0))
{
mandatory += " - " + Msg.Translate(ctx, "SerNo");
}
_changed = true;
}
if (!productWindow && aset.IsGuaranteeDate())
{
log.Fine("GuaranteeDate=" + dtGuaranteeDate);
DateTime?ts = dtGuaranteeDate;
_masi.SetGuaranteeDate(ts);
if (sql.Length > 0)
{
sql.Append(" AND ats.GuaranteeDate = " + GlobalVariable.TO_DATE(dtGuaranteeDate, true));
}
else
{
sql.Append(" ats.GuaranteeDate = " + GlobalVariable.TO_DATE(dtGuaranteeDate, true));
}
if (aset.IsGuaranteeDateMandatory() && ts == null)
{
mandatory += " - " + Msg.Translate(ctx, "GuaranteeDate");
}
_changed = true;
} // GuaranteeDate
if (sql.Length > 0)
{
sql.Insert(0, " where ");
}
sql.Append(" order by ats.m_attributesetinstance_id");
// *** Save Attributes ***
// New Instance
if (_changed || _masi.GetM_AttributeSetInstance_ID() == 0)
{
//_masi.Save();
//obj.M_AttributeSetInstance_ID = _masi.GetM_AttributeSetInstance_ID();
//mAttributeSetInstanceId = _masi.GetM_AttributeSetInstance_ID();
//obj.M_AttributeSetInstanceName = _masi.GetDescription();
}
// Save Instance Attributes
attributes = aset.GetMAttributes(!productWindow);
if (attributes.Length > 0)
{
qry = @"SELECT ats.M_AttributeSetInstance_ID, av.M_AttributeValue_ID,ats.M_AttributeSet_ID,au.Value,att.AttributeValueType FROM M_AttributeSetInstance ats
INNER JOIN M_AttributeInstance au ON ats.M_AttributeSetInstance_ID=au.M_AttributeSetInstance_ID LEFT JOIN M_Attribute att
ON au.M_Attribute_ID=att.M_Attribute_ID LEFT JOIN M_AttributeValue av ON au.M_AttributeValue_ID=av.M_AttributeValue_ID";
}
else
{
qry = @"SELECT ats.M_AttributeSetInstance_ID FROM M_AttributeSetInstance ats ";
}
if (sql.Length > 0)
{
qry += sql;
}
if (attributes.Length > 0)
{
qry += ",au.M_Attribute_ID";
}
ds = DB.ExecuteDataset(qry, null, null);
Dictionary <MAttribute, object> lst = new Dictionary <MAttribute, object>();
for (int i = 0; i < attributes.Length; i++)
{
if (MAttribute.ATTRIBUTEVALUETYPE_List.Equals(attributes[i].GetAttributeValueType()))
{
object editor = editors[i];
MAttributeValue value = null;
if (Convert.ToInt32(editors[i].Key) > 0)
{
value = new MAttributeValue(ctx, Convert.ToInt32(editors[i].Key), null);
value.SetName(editors[i].Name);
}
log.Fine(attributes[i].GetName() + "=" + value);
if (attributes[i].IsMandatory() && value == null)
{
mandatory += " - " + attributes[i].GetName();
}
lst[attributes[i]] = value;
//attributes[i].SetMAttributeInstance(mAttributeSetInstanceId, value);
}
else if (MAttribute.ATTRIBUTEVALUETYPE_Number.Equals(attributes[i].GetAttributeValueType()))
{
object editor = editors[i].Name;
decimal value = Convert.ToDecimal(editor);
log.Fine(attributes[i].GetName() + "=" + value);
if (attributes[i].IsMandatory())
{
mandatory += " - " + attributes[i].GetName();
}
lst[attributes[i]] = value;
//attributes[i].SetMAttributeInstance(mAttributeSetInstanceId, value);
}
else
{
object editor = editors[i].Name;
String value = Convert.ToString(editor);
log.Fine(attributes[i].GetName() + "=" + value);
if (attributes[i].IsMandatory() && (value == null || value.Length == 0))
{
mandatory += " - " + attributes[i].GetName();
}
lst[attributes[i]] = value;
//attributes[i].SetMAttributeInstance(mAttributeSetInstanceId, value);
}
_changed = true;
}
if (_changed)
{
if (mandatory.Length > 0)
{
obj.Error = Msg.GetMsg(ctx, "FillMandatory") + mandatory;
return(obj);
}
if (attributes.Length > 0)
{
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
int attCount = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int attSetID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["M_AttributeSet_ID"]);
string valueType = Util.GetValueOfString(ds.Tables[0].Rows[i]["AttributeValueType"]);
int attributesetinstance_iD = Util.GetValueOfInt(ds.Tables[0].Rows[i]["M_AttributeSetInstance_ID"]);
if (i > 0 && attributesetinstance_iD != Util.GetValueOfInt(ds.Tables[0].Rows[i - 1]["M_AttributeSetInstance_ID"]))
{
attCount = 0;
}
for (int j = 0; j < attributes.Length; j++)
{
if (MAttribute.ATTRIBUTEVALUETYPE_List.Equals(attributes[j].GetAttributeValueType()) && MAttribute.ATTRIBUTEVALUETYPE_List.Equals(valueType))
{
int attID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["M_AttributeValue_ID"]);
MAttributeValue atr = new MAttributeValue(ctx, attID, null);
if (Util.GetValueOfString(atr.GetName()) == Util.GetValueOfString(lst[attributes[j]]) && attSetID == aset.GetM_AttributeSet_ID())
{
attCount += 1;
}
else
{
continue;
}
}
else if (MAttribute.ATTRIBUTEVALUETYPE_Number.Equals(attributes[j].GetAttributeValueType()) && MAttribute.ATTRIBUTEVALUETYPE_Number.Equals(valueType))
{
decimal?attVal = Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["Value"]);
if (attVal == Util.GetValueOfDecimal(lst[attributes[j]]) && attSetID == aset.GetM_AttributeSet_ID())
{
attCount += 1;
}
else
{
continue;
}
}
else if (MAttribute.ATTRIBUTEVALUETYPE_StringMax40.Equals(attributes[j].GetAttributeValueType()) && MAttribute.ATTRIBUTEVALUETYPE_StringMax40.Equals(valueType))
{
string attVal = Util.GetValueOfString(ds.Tables[0].Rows[i]["Value"]);
if (attVal == Util.GetValueOfString(lst[attributes[j]]) && attSetID == aset.GetM_AttributeSet_ID())
{
attCount += 1;
}
else
{
continue;
}
}
}
if (attCount == attributes.Length)
{
mAttributeSetInstanceId = Util.GetValueOfInt(ds.Tables[0].Rows[i]["M_AttributeSetInstance_ID"]);
break;
}
}
if (attCount != attributes.Length)
{
mAttributeSetInstanceId = 0;
}
}
else
{
mAttributeSetInstanceId = 0;
}
}
else
{
mAttributeSetInstanceId = 0;
}
ds.Dispose();
}
else
{
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
mAttributeSetInstanceId = Util.GetValueOfInt(ds.Tables[0].Rows[i]["M_AttributeSetInstance_ID"]);
break;
}
}
else
{
mAttributeSetInstanceId = 0;
}
}
else
{
mAttributeSetInstanceId = 0;
}
ds.Dispose();
}
if (mAttributeSetInstanceId == 0)
{
_masi.Save();
mAttributeSetInstanceId = _masi.GetM_AttributeSetInstance_ID();
obj.M_AttributeSetInstance_ID = _masi.GetM_AttributeSetInstance_ID();
obj.M_AttributeSetInstanceName = _masi.GetDescription();
}
else
{
_masi = new MAttributeSetInstance(ctx, mAttributeSetInstanceId, null);
}
for (int i = 0; i < attributes.Length; i++)
{
if (MAttribute.ATTRIBUTEVALUETYPE_List.Equals(attributes[i].GetAttributeValueType()))
{
MAttributeValue value = lst[attributes[i]] != null ? lst[attributes[i]] as MAttributeValue : null;
attributes[i].SetMAttributeInstance(mAttributeSetInstanceId, value);
}
else if (MAttribute.ATTRIBUTEVALUETYPE_Number.Equals(attributes[i].GetAttributeValueType()))
{
attributes[i].SetMAttributeInstance(mAttributeSetInstanceId, (decimal?)lst[attributes[i]]);
}
else
{
attributes[i].SetMAttributeInstance(mAttributeSetInstanceId, (String)lst[attributes[i]]);
}
}
if (attributeID == 0 && strAttrCode != "")
{
MProductAttributes pAttr = new MProductAttributes(ctx, 0, null);
pAttr.SetUPC(strAttrCode);
pAttr.SetM_Product_ID(mProductId);
pAttr.SetM_AttributeSetInstance_ID(mAttributeSetInstanceId);
pAttr.Save();
}
_masi.SetDescription();
_masi.Save();
mAttributeSetInstanceId = _masi.GetM_AttributeSetInstance_ID();
obj.M_AttributeSetInstance_ID = _masi.GetM_AttributeSetInstance_ID();
obj.M_AttributeSetInstanceName = _masi.GetDescription();
//
if (attributeID != 0 && (attributeID != mAttributeSetInstanceId || product_id != mProductId))
{
obj.Error = Msg.GetMsg(ctx, "AttributeCodeExists");
}
}
else
{
obj.M_AttributeSetInstance_ID = _masi.GetM_AttributeSetInstance_ID();
obj.M_AttributeSetInstanceName = _masi.GetDescription();
}
return(obj);
}
public KeyNamePair GetAttribute(Ctx ctx, string fields)
{
string[] paramValue = fields.Split(',');
int M_Product_ID = 0;
string attributeNo = "", isLot = "", IsSerNo = "", IsGuaranteeDate = "", RefNo = "";
DateTime?expiryDate = null;
if (paramValue.Length > 0)
{
M_Product_ID = Util.GetValueOfInt(paramValue[0]);
attributeNo = Util.GetValueOfString(paramValue[1]);
isLot = Util.GetValueOfString(paramValue[2]);
IsSerNo = Util.GetValueOfString(paramValue[3]);
IsGuaranteeDate = Util.GetValueOfString(paramValue[4]);
expiryDate = Util.GetValueOfDateTime(paramValue[5]);
RefNo = Util.GetValueOfString(paramValue[6]);
}
string qry = "";
int attrID = 0;
string name = "";
KeyNamePair attribute = null;
StringBuilder sql = new StringBuilder();
MAttributeSetInstance _mast = MAttributeSetInstance.Get(Env.GetCtx(), 0, M_Product_ID);
if (!string.IsNullOrEmpty(attributeNo))
{
qry = "SELECT M_AttributeSetInstance_ID FROM M_ProductAttributes WHERE M_Product_ID = " + M_Product_ID + "AND UPC = '" + attributeNo + "'";
attrID = Util.GetValueOfInt(DB.ExecuteScalar(qry));
if (attrID == 0)
{
if (isLot == "Y")
{
_mast.SetLot(attributeNo);
sql.Append("UPPER(Lot) = " + attributeNo.ToUpper());
}
else if (IsSerNo == "Y")
{
_mast.SetSerNo(attributeNo);
sql.Append(" UPPER(SerNo) = " + attributeNo.ToUpper());
}
_mast.SetDescription(attributeNo);
if (IsGuaranteeDate == "Y")
{
if (sql.Length > 0)
{
sql.Append(" AND GuaranteeDate = " + GlobalVariable.TO_DATE(expiryDate, true));
}
else
{
sql.Append(" GuaranteeDate = " + GlobalVariable.TO_DATE(expiryDate, true));
}
_mast.SetGuaranteeDate(expiryDate);
if (!String.IsNullOrEmpty(attributeNo))
{
_mast.SetDescription(attributeNo + "_" + expiryDate);
}
else
{
_mast.SetDescription(expiryDate.ToString());
}
}
qry = @"SELECT M_AttributeSetInstance_ID FROM M_AttributeSetINstance";
if (sql.Length > 0)
{
sql.Insert(0, " where ");
qry += sql + " order by m_attributesetinstance_id";
}
else
{
qry = "";
}
if (qry != "")
{
attrID = Util.GetValueOfInt(DB.ExecuteScalar(qry, null, null));
if (attrID == 0)
{
if (_mast.Save())
{
attrID = _mast.GetM_AttributeSetInstance_ID();
name = _mast.GetDescription();
}
}
}
}
if (attrID > 0)
{
MAttributeSetInstance mas = new MAttributeSetInstance(ctx, attrID, null);
name = mas.GetDescription();
}
attribute = new KeyNamePair(attrID, name);
}
return(attribute);
}
public List <String> GetAttributeInstance(int _M_AttributeSetInstance_ID, int _M_Product_ID, bool _productWindow, int windowNo, Ctx ctx, int AD_Column_ID, int attrcode)
{
List <String> attrValues = new List <String>();
int attr_ID = 0;
StringBuilder sql = new StringBuilder();
MAttributeSet aset = null;
MAttribute[] attributes = null;
MAttributeSetInstance _masi = MAttributeSetInstance.Get(ctx, _M_AttributeSetInstance_ID, _M_Product_ID);
// Get Attribute Set
aset = _masi.GetMAttributeSet();
// Product has no Attribute Set
if (aset == null)
{
Msg.GetMsg("PAttributeNoAttributeSet", null);
return(null);;
}
string attrsetQry = @"SELECT ats.M_AttributeSet_ID FROM M_ProductAttributes patr LEFT JOIN M_AttributeSetInstance ats
ON (patr.M_AttributeSetInstance_ID=ats.M_AttributeSetInstance_ID) where patr.UPC='" + attrcode + "'";
int attributeSet = Util.GetValueOfInt(DB.ExecuteScalar(attrsetQry));
if (attributeSet != aset.Get_ID())
{
return(null);
}
if (!_productWindow && aset.IsLot())
{
sql.Append("SELECT ats.Lot,ats.SerNo,ats.GuaranteeDate ");
} // Lot
//if (!_productWindow && aset.IsSerNo())
//{
// sql.Append(" SELECT ats.SerNo");
//}
//if (!_productWindow && aset.IsGuaranteeDate())
//{
// if (sql.Length > 0)
// {
// sql.Append(",ats.GuaranteeDate");
// }
// else
// {
// sql.Append("SELECT ats.GuaranteeDate");
// }
//} // GuaranteeDate
if (sql.Length > 0)
{
sql.Append(@" FROM M_ProductAttributes patr INNER JOIN M_AttributeSetInstance ats ON (patr.m_attributesetinstance_id=ats.m_attributesetinstance_id) WHERE patr.UPC='" + attrcode + "'");
DataSet ds1 = null;
try
{
ds1 = DB.ExecuteDataset(sql.ToString(), null, null);
if (ds1 != null)
{
if (ds1.Tables[0].Rows.Count > 0)
{
if (!_productWindow && aset.IsLot())
{
attrValues.Add(Util.GetValueOfString(ds1.Tables[0].Rows[0]["Lot"]));
} // Lot
else
{
attrValues.Add("");
}
if (!_productWindow && aset.IsSerNo())
{
attrValues.Add(Util.GetValueOfString(ds1.Tables[0].Rows[0]["SerNo"]));
}
else
{
attrValues.Add("");
}
if (!_productWindow && aset.IsGuaranteeDate())
{
attrValues.Add(Util.GetValueOfString(ds1.Tables[0].Rows[0]["GuaranteeDate"]));
} // GuaranteeDate
else
{
attrValues.Add("");
}
ds1.Dispose();
}
else
{
ds1.Dispose();
}
}
else
{
ds1.Dispose();
}
}
catch
{
attrValues.Clear();
}
finally
{
ds1.Dispose();
}
}
if (attrValues.Count == 0)
{
attrValues.Add("");
attrValues.Add("");
attrValues.Add("");
}
return(attrValues);
}
//Dictionary<MAttribute, KeyValuePair<MAttributeInstance, MAttributeValue[]>> attributesList = new Dictionary<MAttribute, KeyValuePair<MAttributeInstance, MAttributeValue[]>>(4);
public AttributesObjects LoadInit(int _M_AttributeSetInstance_ID, int _M_Product_ID, bool _productWindow, int windowNo, Ctx ctx, int AD_Column_ID, int window_ID, bool IsSOTrx, string IsInternalUse)
{
AttributesObjects obj = new AttributesObjects();
MAttributeSet aset = null;
MAttribute[] attributes = null;
// Get Model
MAttributeSetInstance _masi = MAttributeSetInstance.Get(ctx, _M_AttributeSetInstance_ID, _M_Product_ID);
MProduct _prd = new MProduct(ctx, _M_Product_ID, null);
if (_masi == null)
{
obj.IsReturnNull = true;
obj.Error = "No Model for M_AttributeSetInstance_ID=" + _M_AttributeSetInstance_ID + ", M_Product_ID=" + _M_Product_ID;
return(obj);
}
// Get Attribute Set
aset = _masi.GetMAttributeSet();
// Product has no Attribute Set
if (aset == null)
{
obj.IsReturnNull = true;
obj.Error = "PAttributeNoAttributeSet";
return(obj);
}
obj.MAttributeSetID = aset.Get_ID();
// Product has no Instance Attributes
if (!_productWindow && !aset.IsInstanceAttribute())
{
obj.Error = "NPAttributeNoInstanceAttribute=";
return(obj);
}
if (_productWindow)
{
attributes = aset.GetMAttributes(false);
}
else
{
attributes = aset.GetMAttributes(true);
}
//Row 0
obj.tableStucture = "<table style='width: 100%;'><tr>";
if (_productWindow)
{
for (int i = 0; i < attributes.Length; i++)
{
obj.tableStucture = AddAttributeLine(attributes[i], _M_AttributeSetInstance_ID, true, false, windowNo, obj, i);
}
}
else
{
var newEditContent = VAdvantage.Utility.Util.CleanMnemonic(Msg.GetMsg(ctx, "NewRecord"));
if (_M_AttributeSetInstance_ID > 0)
{
newEditContent = VAdvantage.Utility.Util.CleanMnemonic(Msg.GetMsg(ctx, "EditRecord"));
}
//column 1
obj.tableStucture += "<td style = 'visibility: hidden;'>";
obj.tableStucture += "<input type='checkbox' id='chkNewEdit_" + windowNo + "' ><label class='VIS_Pref_Label_Font'>" + newEditContent + "</label>";
obj.tableStucture += "</td>";
//column 2
obj.tableStucture += "<td>";
obj.tableStucture += "<button type='button' style='margin-bottom: 10px;' id='btnSelect_" + windowNo + "' role='button' aria-disabled='false'><img style='float: left;' src='~/Areas/VIS/Images/base/Delete24.PNG' /><span style='float: left;margin-left: 5px;margin-right: 5px;' >" + VAdvantage.Utility.Util.CleanMnemonic(Msg.GetMsg(ctx, "SelectExisting")) + "</span></button>";
obj.tableStucture += "</td>";
obj.tableStucture += "</tr>";
//Change 20-May-2015 Bharat
var label = Msg.Translate(ctx, "AttrCode");
obj.tableStucture += "<tr>";
obj.tableStucture += "<td>";
obj.tableStucture += "<label style='padding-bottom: 10px; padding-right: 5px;' id=lot_" + windowNo + "' class='VIS_Pref_Label_Font'>" + label + "</label>";
obj.tableStucture += "</td>";
//column 2
obj.tableStucture += "<td>";
obj.tableStucture += "<input style='width: 100%;' id='txtAttrCode_" + windowNo + "' value='' class='VIS_Pref_pass' type='text'>";
obj.tableStucture += "</td>";
obj.tableStucture += "</tr>";
//Row 1
obj.tableStucture += "<tr>";
// All Attributes
for (int i = 0; i < attributes.Length; i++)
{
obj.tableStucture = AddAttributeLine(attributes[i], _M_AttributeSetInstance_ID, true, false, windowNo, obj, i);
}
}
// Lot
if (!_productWindow && aset.IsLot())
{
//column 1
var label = Msg.Translate(ctx, "Lot");
obj.tableStucture += "<td>";
obj.tableStucture += "<label style='padding-bottom: 10px; padding-right: 5px;' id=lot_" + windowNo + "' class='VIS_Pref_Label_Font'>" + label + "</label>";
obj.tableStucture += "</td>";
//column 2
obj.tableStucture += "<td>";
obj.tableStucture += "<input style='width: 100%;' id='txtLotString_" + windowNo + "' value='" + _masi.GetLot() + "' class='VIS_Pref_pass' type='text'>";
obj.tableStucture += "</td>";
obj.tableStucture += "</tr>";
//Row 1
if (!IsSOTrx || IsInternalUse == "N" || window_ID == 191 || window_ID == 140)
{
obj.tableStucture += "<tr>";
//column 1
label = Msg.Translate(ctx, "M_Lot_ID");
obj.tableStucture += "<td>";
obj.tableStucture += "<label style='padding-bottom: 10px; padding-right: 5px;' id=M_Lot_ID_" + windowNo + "' class='VIS_Pref_Label_Font'>" + label + "</label>";
obj.tableStucture += "</td>";
String sql = "SELECT M_Lot_ID, Name "
+ "FROM M_Lot l "
+ "WHERE EXISTS (SELECT M_Product_ID FROM M_Product p "
+ "WHERE p.M_AttributeSet_ID=" + _masi.GetM_AttributeSet_ID()
+ " AND p.M_Product_ID=l.M_Product_ID)";
KeyNamePair[] data = DB.GetKeyNamePairs(sql, true);
//column 2
obj.tableStucture += "<td>";
obj.tableStucture += "<select style='width: 100%;margin-bottom: 10px;' id='cmbLot_" + windowNo + "'>";
obj.tableStucture += " <option selected value='" + 0 + "' > </option>";
for (int i = 1; i < data.Length; i++)
{
if (Convert.ToInt32(data[i].Key) == _masi.GetM_Lot_ID())
{
obj.tableStucture += " <option selected value='" + data[i].Key + "' >" + data[i].Name + "</option>";
}
else
{
obj.tableStucture += " <option value='" + data[i].Key + "' >" + data[i].Name + "</option>";
}
}
obj.tableStucture += "</select>";
obj.tableStucture += "</td>";
obj.tableStucture += "</tr>";
//Row 2
obj.tableStucture += "<tr>";
// New Lot Button
if (_masi.GetMAttributeSet().GetM_LotCtl_ID() != 0)
{
if (MRole.GetDefault(ctx).IsTableAccess(MLot.Table_ID, false) && MRole.GetDefault(ctx).IsTableAccess(MLotCtl.Table_ID, false))
{
if (!_masi.IsExcludeLot(AD_Column_ID, IsSOTrx))//_windowNoParent
{
//column 1
obj.tableStucture += "<td></td>";
//column 2
obj.tableStucture += "<td>";
obj.tableStucture += "<button type='button' style='margin-bottom: 10px;' id='btnLot_" + windowNo + "' role='button' aria-disabled='false'><span >" + VAdvantage.Utility.Util.CleanMnemonic(Msg.GetMsg(ctx, "New")) + "</span></button>";
obj.tableStucture += "</td>";
obj.tableStucture += "</tr>";
//Row 3
obj.tableStucture += "<tr>";
}
}
}
}
//mZoom = new System.Windows.Forms.ToolStripMenuItem(Msg.GetMsg(Env.GetContext(), "Zoom"), Env.GetImageIcon("Zoom16.gif"));
//mZoom.Click += new EventHandler(mZoom_Click);
//ctxStrip.Items.Add(mZoom);
}
// SerNo
if (!_productWindow && aset.IsSerNo())
{
//column 1
var label = Msg.Translate(ctx, "SerNo");
obj.tableStucture += "<td>";
obj.tableStucture += "<label style='padding-bottom: 10px; padding-right: 5px;' id=SerNo_" + windowNo + "' class='VIS_Pref_Label_Font'>" + label + "</label>";
obj.tableStucture += "</td>";
//column 2
// txtSerNo.Text = _masi.GetSerNo();
obj.tableStucture += "<td>";
obj.tableStucture += "<input style='width: 100%;' id='txtSerNo_" + windowNo + "' value='" + _masi.GetSerNo() + "' class='VIS_Pref_pass' type='text'>";
obj.tableStucture += "</td>";
obj.tableStucture += "</tr>";
//Row 1
obj.tableStucture += "<tr>";
// New SerNo Button
if (_masi.GetMAttributeSet().GetM_SerNoCtl_ID() != 0)
{
if (MRole.GetDefault(ctx).IsTableAccess(MSerNoCtl.Table_ID, false))
{
if (!_masi.IsExcludeSerNo(AD_Column_ID, IsSOTrx))//_windowNoParent
{
//column 1
obj.tableStucture += "<td></td>";
obj.tableStucture += "<td>";
obj.tableStucture += "<button type='button' style='margin-bottom: 10px;' id='btnSerNo_" + windowNo + "' role='button' aria-disabled='false'><span >" + VAdvantage.Utility.Util.CleanMnemonic(Msg.GetMsg(ctx, "New")) + "</span></button>";
obj.tableStucture += "</td>";
}
obj.tableStucture += "</tr>";
//Row 2
obj.tableStucture += "<tr>";
}
}
} // SerNo
//// GuaranteeDate
if (!_productWindow && aset.IsGuaranteeDate())
{
var dtpicGuaranteeDate = TimeUtil.AddDays(DateTime.Now, _prd.GetGuaranteeDays());
if (_M_AttributeSetInstance_ID > 0)
{
dtpicGuaranteeDate = (DateTime)(_masi.GetGuaranteeDate());
}
var label = Msg.Translate(ctx, "GuaranteeDate");
//Column 1
obj.tableStucture += "<td>";
obj.tableStucture += "<label style='padding-bottom: 10px; padding-right: 5px;' id='guaranteeDate_" + windowNo + "' class='VIS_Pref_Label_Font'>" + label + "</label>";
obj.tableStucture += "</td>";
//Column 2
obj.tableStucture += "<td>";
//obj.tableStucture += "<input style='width: 100%;' value='" + String.Format("{0:yyyy-MM-dd}", dtpicGuaranteeDate) + "' type='date' id='dtpicGuaranteeDate_" + windowNo + "' class='VIS_Pref_pass'/>";
obj.tableStucture += "<input style='width: 100%;' value='" + String.Format("{0:yyyy-MM-dd}", dtpicGuaranteeDate) + "' type='date' id='dtpicGuaranteeDate_" + windowNo + "' class='VIS_Pref_pass'/>";
obj.tableStucture += "</td>";
obj.tableStucture += "</tr>";
//Row 2
obj.tableStucture += "<tr>";
}
//string[] sep = new string[1];
//sep[0] = "<tr>";
//sep = obj.tableStucture.Split(sep, StringSplitOptions.RemoveEmptyEntries);
//if (sep.Length <= 3)
//{
// obj.Error = "PAttributeNoInfo";
// obj.IsReturnNull = true;
// return null;
//}
// New/Edit Window
if (!_productWindow)
{
//chkNewEdit.IsChecked = _M_AttributeSetInstance_ID == 0;
}
// Attrribute Set Instance Description
//Column 1
var label1 = Msg.Translate(ctx, "Description");
obj.tableStucture += "<td>";
obj.tableStucture += "<label style='padding-bottom: 10px; padding-right: 5px;' id='description_" + windowNo + "' class='VIS_Pref_Label_Font'>" + label1 + "</label>";
obj.tableStucture += "</td>";
//Column 2
obj.tableStucture += "<td>";
obj.tableStucture += "<input style='width: 100%;' readonly id='txtDescription_" + windowNo + "' value='" + _masi.GetDescription() + "' class='VIS_Pref_pass vis-gc-vpanel-table-readOnly' type='text'>";
obj.tableStucture += "</td>";
obj.tableStucture += "</tr>";
//Add Ok and Cancel button
//Last row
obj.tableStucture += "<tr>";
obj.tableStucture += "<td style='text-align:right' colspan='2'>";
obj.tableStucture += "<button style='margin-bottom:0px;margin-top:0px; float:right' type='button' class='VIS_Pref_btn-2' style='float: right;' id='btnCancel_" + windowNo + "' role='button' aria-disabled='false'>" + VAdvantage.Utility.Util.CleanMnemonic(Msg.GetMsg(ctx, "Cancel")) + "</button>";
obj.tableStucture += "<button style='margin-bottom:0px;margin-top:0px; float:right; margin-right: 10px;' type='button' class='VIS_Pref_btn-2' style='float: right; margin-right: 10px;' id='btnOk_" + windowNo + "' role='button' aria-disabled='false'>" + VAdvantage.Utility.Util.CleanMnemonic(Msg.GetMsg(ctx, "OK")) + "</button>";
obj.tableStucture += "</td>";
obj.tableStucture += "</tr>";
obj.tableStucture += "</table>";
if (obj.ControlList != null)
{
if (obj.ControlList.Length > 1)
{
obj.ControlList = obj.ControlList.Substring(0, obj.ControlList.Length - 1);
}
;
}
return(obj);
}
public List <String> GetAttribute(int _M_AttributeSetInstance_ID, int _M_Product_ID, bool _productWindow, int windowNo, Ctx ctx, int AD_Column_ID, int attrcode)
{
List <String> attrValues = new List <String>();
int attr_ID = 0;
StringBuilder sql = new StringBuilder();
MAttributeSet aset = null;
MAttribute[] attributes = null;
MAttributeSetInstance _masi = MAttributeSetInstance.Get(ctx, _M_AttributeSetInstance_ID, _M_Product_ID);
// Get Attribute Set
aset = _masi.GetMAttributeSet();
// Product has no Attribute Set
if (aset == null)
{
Msg.GetMsg("PAttributeNoAttributeSet", null);
return(null);;
}
string attrsetQry = @"SELECT ats.M_AttributeSet_ID FROM M_ProductAttributes patr LEFT JOIN M_AttributeSetInstance ats
ON (patr.M_AttributeSetInstance_ID=ats.M_AttributeSetInstance_ID) where patr.UPC='" + attrcode + "'";
int attributeSet = Util.GetValueOfInt(DB.ExecuteScalar(attrsetQry));
if (attributeSet != aset.Get_ID())
{
return(null);
}
//// Product has no Instance Attributes
//if (!_productWindow && !aset.IsInstanceAttribute())
//{
// Dispatcher.BeginInvoke(() => Classes.ShowMessage.Error("PAttributeNoInstanceAttribute", null));
// //ADialog.error(m_WindowNo, this, "PAttributeNoInstanceAttribute");
// return;
//}
if (_productWindow)
{
attributes = aset.GetMAttributes(false);
log.Fine("Product Attributes=" + attributes.Length);
}
else
{
attributes = aset.GetMAttributes(true);
}
if (attributes.Length > 0)
{
string attrQry = @"SELECT ats.M_Attribute_ID,ats.M_AttributeValue_ID,ats.Value,att.attributevaluetype FROM M_ProductAttributes patr LEFT JOIN M_AttributeInstance ats
ON (patr.M_AttributeSetInstance_ID=ats.M_AttributeSetInstance_ID) inner join M_attributesetinstance ast ON (patr.M_AttributeSetInstance_ID=ast.M_AttributeSetInstance_ID)
LEFT JOIN M_Attribute att ON ats.M_Attribute_ID=att.M_Attribute_ID
where patr.UPC='" + attrcode + "' AND ast.M_AttributeSet_ID = " + _masi.GetM_AttributeSet_ID() + " Order By ats.M_Attribute_ID";
DataSet ds = null;
try
{
ds = DB.ExecuteDataset(attrQry, null, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (Util.GetValueOfString(ds.Tables[0].Rows[i]["AttributeValueType"]) == "L")
{
attrValues.Add(Util.GetValueOfString(ds.Tables[0].Rows[i]["M_AttributeValue_ID"]));
}
else
{
attrValues.Add(Util.GetValueOfString(ds.Tables[0].Rows[i]["Value"]));
}
}
ds.Dispose();
}
else
{
ds.Dispose();
}
}
else
{
ds.Dispose();
}
}
catch
{
}
finally
{
ds.Dispose();
}
}
if (attrValues.Count == 0)
{
attrValues.Add("");
}
return(attrValues);
}
public KeyNamePair CreateLot(Ctx ctx, int M_AttributeSetInstance_ID, int M_Product_ID)
{
var masi = MAttributeSetInstance.Get(ctx, M_AttributeSetInstance_ID, M_Product_ID);
return(masi.CreateLot(M_Product_ID));
}
public string GetSerNo(Ctx ctx, int M_AttributeSetInstance_ID, int M_Product_ID)
{
var masi = MAttributeSetInstance.Get(ctx, M_AttributeSetInstance_ID, M_Product_ID);
return(masi.GetSerNo(true));
}
// Create Asset From Invoice Mohit
/**
* Shipment Constructor
* @param Invoice
* @param shipLine shipment line
* @param deliveryCount 0 or number of delivery
*/
public MAsset(MInvoice invoice, MInvoiceLine invoiceline, int deliveryCount)
: this(invoiceline.GetCtx(), 0, invoiceline.Get_TrxName())
{
SetClientOrg(invoiceline);
SetValueNameDescription(invoice, invoiceline, deliveryCount);
// Header
//SetIsOwned(true);
SetC_BPartner_ID(invoice.GetC_BPartner_ID());
SetC_BPartner_Location_ID(invoice.GetC_BPartner_Location_ID());
SetAD_User_ID(invoice.GetAD_User_ID());
//SetM_Locator_ID(invoice.GetM_Locator_ID());
SetIsInPosession(true);
SetAssetServiceDate(invoice.GetDateAcct());
// Line
MProduct product = invoiceline.GetProduct();
SetM_Product_ID(product.GetM_Product_ID());
SetA_Asset_Group_ID(product.GetA_Asset_Group_ID());
//////////////////////////////*
//Changes for vafam
// SetAssetServiceDate(shipment.GetMovementDate());
//SetGuaranteeDate(TimeUtil.AddDays(shipment.GetMovementDate(), product.GetGuaranteeDays()));
MAssetGroup _assetGroup = new MAssetGroup(GetCtx(), GetA_Asset_Group_ID(), invoice.Get_TrxName());
if (_assetGroup.IsOwned())
{
SetIsOwned(true);
//SetC_BPartner_ID(0);
}
if (_assetGroup.IsDepreciated())
{
SetIsDepreciated(true);
SetIsFullyDepreciated(false);
}
////////////////////////////////////
//Change by Sukhwinder for setting Asset type and amortization template on Asset window, MANTIS ID:1762
int countVA038 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA038_' "));
Set_Value("VAFAM_AssetType", _assetGroup.Get_Value("VAFAM_AssetType").ToString());
if (countVA038 > 0)
{
Set_Value("VA038_AmortizationTemplate_ID", VAdvantage.Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VA038_AmortizationTemplate_ID")));
}
Set_Value("VAFAM_DepreciationType_ID", VAdvantage.Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VAFAM_DepreciationType_ID")));
////////////////////////////////////
// Guarantee & Version
SetGuaranteeDate(TimeUtil.AddDays(invoice.GetDateInvoiced(), product.GetGuaranteeDays()));
SetVersionNo(product.GetVersionNo());
if (invoiceline.GetM_AttributeSetInstance_ID() != 0) // Instance
{
MAttributeSetInstance asi = new MAttributeSetInstance(GetCtx(), invoiceline.GetM_AttributeSetInstance_ID(), Get_TrxName());
SetM_AttributeSetInstance_ID(asi.GetM_AttributeSetInstance_ID());
SetLot(asi.GetLot());
SetSerNo(asi.GetSerNo());
}
SetHelp(invoiceline.GetDescription());
// Qty
int units = product.GetSupportUnits();
if (units == 0)
{
units = 1;
}
if (deliveryCount != 0) // one asset per UOM
{
SetQty(invoiceline.GetQtyEntered(), units);
}
else
{
SetQty((Decimal)units);
}
SetM_InOutLine_ID(invoiceline.GetM_InOutLine_ID());
Set_Value("C_InvoiceLine_ID", invoiceline.GetC_InvoiceLine_ID());
// Activate
MAssetGroup ag = MAssetGroup.Get(GetCtx(), GetA_Asset_Group_ID());
if (!ag.IsCreateAsActive())
{
SetIsActive(false);
}
}
} // prepare
/// <summary>
/// Perrform Process.
/// </summary>
/// <returns>Info</returns>
protected override String DoIt()
{
log.Info("M_Locator_ID=" + _M_Locator_ID + ",MovementDate=" + _MovementDate);
//
StringBuilder sql = null;
int no = 0;
String clientCheck = " AND AD_Client_ID=" + _AD_Client_ID;
// **** Prepare ****
// Delete Old Imported
if (_DeleteOldImported)
{
sql = new StringBuilder("DELETE FROM I_Inventory "
+ "WHERE I_IsImported='Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Delete Old Impored =" + no);
}
// Set Client, Org, Location, IsActive, Created/Updated
sql = new StringBuilder("UPDATE I_Inventory "
+ "SET AD_Client_ID = COALESCE (AD_Client_ID,").Append(_AD_Client_ID).Append("),"
+ " AD_Org_ID = COALESCE (AD_Org_ID,").Append(_AD_Org_ID).Append("),");
if (_MovementDate != null)
{
sql.Append(" MovementDate = COALESCE (MovementDate,").Append(DataBase.DB.TO_DATE(_MovementDate)).Append("),");
}
sql.Append(" IsActive = COALESCE (IsActive, 'Y'),"
+ " Created = COALESCE (Created, SysDate),"
+ " CreatedBy = COALESCE (CreatedBy, 0),"
+ " Updated = COALESCE (Updated, SysDate),"
+ " UpdatedBy = COALESCE (UpdatedBy, 0),"
+ " I_ErrorMsg = NULL,"
+ " M_Warehouse_ID = NULL," // reset
+ " I_IsImported = 'N' "
+ "WHERE I_IsImported<>'Y' OR I_IsImported IS NULL");
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Info("Reset=" + no);
String ts = DataBase.DB.IsPostgreSQL() ? "COALESCE(I_ErrorMsg,'')" : "I_ErrorMsg"; //java bug, it could not be used directly
sql = new StringBuilder("UPDATE I_Inventory o "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||'ERR=Invalid Org, '"
+ "WHERE (AD_Org_ID IS NULL OR AD_Org_ID=0"
+ " OR EXISTS (SELECT * FROM AD_Org oo WHERE o.AD_Org_ID=oo.AD_Org_ID AND (oo.IsSummary='Y' OR oo.IsActive='N')))"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
if (no != 0)
{
log.Warning("Invalid Org=" + no);
}
// gwu: bug 1703137
// if Warehouse key provided, get Warehouse ID
sql = new StringBuilder("UPDATE I_Inventory i "
+ "SET M_Warehouse_ID=(SELECT MAX(M_Warehouse_ID) FROM M_Warehouse w"
+ " WHERE i.WarehouseValue=w.Value AND i.AD_Client_ID=w.AD_Client_ID) "
+ "WHERE M_Warehouse_ID IS NULL AND WarehouseValue IS NOT NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Warehouse from Value =" + no);
// Location
sql = new StringBuilder("UPDATE I_Inventory i "
+ "SET M_Locator_ID=(SELECT MAX(M_Locator_ID) FROM M_Locator l"
+ " WHERE i.LocatorValue=l.Value AND COALESCE (i.M_Warehouse_ID, l.M_Warehouse_ID)=l.M_Warehouse_ID AND i.AD_Client_ID=l.AD_Client_ID) "
+ "WHERE M_Locator_ID IS NULL AND LocatorValue IS NOT NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Locator from Value =" + no);
sql = new StringBuilder("UPDATE I_Inventory i "
+ "SET M_Locator_ID=(SELECT MAX(M_Locator_ID) FROM M_Locator l"
+ " WHERE i.X=l.X AND i.Y=l.Y AND i.Z=l.Z AND COALESCE (i.M_Warehouse_ID, l.M_Warehouse_ID)=l.M_Warehouse_ID AND i.AD_Client_ID=l.AD_Client_ID) "
+ "WHERE M_Locator_ID IS NULL AND X IS NOT NULL AND Y IS NOT NULL AND Z IS NOT NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Locator from X,Y,Z =" + no);
if (_M_Locator_ID != 0)
{
sql = new StringBuilder("UPDATE I_Inventory "
+ "SET M_Locator_ID = ").Append(_M_Locator_ID).Append(
" WHERE M_Locator_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Locator from Parameter=" + no);
}
sql = new StringBuilder("UPDATE I_Inventory "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||'ERR=No Location, ' "
+ "WHERE M_Locator_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
if (no != 0)
{
log.Warning("No Location=" + no);
}
// Set M_Warehouse_ID
sql = new StringBuilder("UPDATE I_Inventory i "
+ "SET M_Warehouse_ID=(SELECT M_Warehouse_ID FROM M_Locator l WHERE i.M_Locator_ID=l.M_Locator_ID) "
+ "WHERE M_Locator_ID IS NOT NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Warehouse from Locator =" + no);
sql = new StringBuilder("UPDATE I_Inventory "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||'ERR=No Warehouse, ' "
+ "WHERE M_Warehouse_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
if (no != 0)
{
log.Warning("No Warehouse=" + no);
}
// Product
sql = new StringBuilder("UPDATE I_Inventory i "
+ "SET M_Product_ID=(SELECT MAX(M_Product_ID) FROM M_Product p"
+ " WHERE i.Value=p.Value AND i.AD_Client_ID=p.AD_Client_ID) "
+ "WHERE M_Product_ID IS NULL AND Value IS NOT NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Product from Value=" + no);
sql = new StringBuilder("UPDATE I_Inventory i "
+ "SET M_Product_ID=(SELECT MAX(M_Product_ID) FROM M_Product p"
+ " WHERE i.UPC=p.UPC AND i.AD_Client_ID=p.AD_Client_ID) "
+ "WHERE M_Product_ID IS NULL AND UPC IS NOT NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Product from UPC=" + no);
sql = new StringBuilder("UPDATE I_Inventory "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||'ERR=No Product, ' "
+ "WHERE M_Product_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
if (no != 0)
{
log.Warning("No Product=" + no);
}
// No QtyCount
sql = new StringBuilder("UPDATE I_Inventory "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||'ERR=No Qty Count, ' "
+ "WHERE QtyCount IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
if (no != 0)
{
log.Warning("No QtyCount=" + no);
}
Commit();
/*********************************************************************/
MInventory inventory = null;
int noInsert = 0;
int noInsertLine = 0;
// Go through Inventory Records
sql = new StringBuilder("SELECT * FROM I_Inventory "
+ "WHERE I_IsImported='N'").Append(clientCheck)
.Append(" ORDER BY M_Warehouse_ID, TRUNC(MovementDate,'DD'), I_Inventory_ID");
IDataReader idr = null;
try
{
//PreparedStatement pstmt = DataBase.prepareStatement (sql.ToString (), Get_TrxName());
//ResultSet rs = pstmt.executeQuery ();
idr = DataBase.DB.ExecuteReader(sql.ToString(), null, Get_TrxName());
//
int x_M_Warehouse_ID = -1;
DateTime?x_MovementDate = null;
while (idr.Read())
{
X_I_Inventory imp = new X_I_Inventory(GetCtx(), idr, Get_TrxName());
DateTime? MovementDate = TimeUtil.GetDay(imp.GetMovementDate());
if (inventory == null ||
imp.GetM_Warehouse_ID() != x_M_Warehouse_ID ||
!MovementDate.Equals(x_MovementDate))
{
inventory = new MInventory(GetCtx(), 0, Get_TrxName());
inventory.SetClientOrg(imp.GetAD_Client_ID(), imp.GetAD_Org_ID());
inventory.SetDescription("I " + imp.GetM_Warehouse_ID() + " " + MovementDate);
inventory.SetM_Warehouse_ID(imp.GetM_Warehouse_ID());
inventory.SetMovementDate(MovementDate);
//
if (!inventory.Save())
{
log.Log(Level.SEVERE, "Inventory not saved");
break;
}
x_M_Warehouse_ID = imp.GetM_Warehouse_ID();
x_MovementDate = MovementDate;
noInsert++;
}
// Line
int M_AttributeSetInstance_ID = 0;
if (imp.GetLot() != null || imp.GetSerNo() != null)
{
MProduct product = MProduct.Get(GetCtx(), imp.GetM_Product_ID());
if (product.IsInstanceAttribute())
{
MAttributeSet mas = product.GetAttributeSet();
MAttributeSetInstance masi = new MAttributeSetInstance(GetCtx(), 0, mas.GetM_AttributeSet_ID(), Get_TrxName());
if (mas.IsLot() && imp.GetLot() != null)
{
masi.SetLot(imp.GetLot(), imp.GetM_Product_ID());
}
if (mas.IsSerNo() && imp.GetSerNo() != null)
{
masi.SetSerNo(imp.GetSerNo());
}
masi.SetDescription();
masi.Save();
M_AttributeSetInstance_ID = masi.GetM_AttributeSetInstance_ID();
}
}
MInventoryLine line = new MInventoryLine(inventory,
imp.GetM_Locator_ID(), imp.GetM_Product_ID(), M_AttributeSetInstance_ID,
imp.GetQtyBook(), imp.GetQtyCount());
if (line.Save())
{
imp.SetI_IsImported(X_I_Inventory.I_ISIMPORTED_Yes);
imp.SetM_Inventory_ID(line.GetM_Inventory_ID());
imp.SetM_InventoryLine_ID(line.GetM_InventoryLine_ID());
imp.SetProcessed(true);
if (imp.Save())
{
noInsertLine++;
}
}
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, sql.ToString(), e);
}
// Set Error to indicator to not imported
sql = new StringBuilder("UPDATE I_Inventory "
+ "SET I_IsImported='N', Updated=SysDate "
+ "WHERE I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
AddLog(0, null, Utility.Util.GetValueOfDecimal(no), "@Errors@");
//
AddLog(0, null, Utility.Util.GetValueOfDecimal(noInsert), "@M_Inventory_ID@: @Inserted@");
AddLog(0, null, Utility.Util.GetValueOfDecimal(noInsertLine), "@M_InventoryLine_ID@: @Inserted@");
return("");
} // doIt
