public int Update(SqlTransaction trans, AllocationModel model)
{
int num = 0;
if (model.Acode != "")
{
num = AllocationAction.Update(trans, model);
}
return(num);
}
public int Delete(SqlTransaction trans, string acode)
{
int num = 0;
if (acode != "")
{
num = AllocationAction.Delete(trans, acode);
}
return(num);
}
public DataTable GetMaterialOfDepositoryList(string depositoryId, string strWhere)
{
DataTable materialOfDepositoryList = new DataTable();
if (depositoryId != "")
{
materialOfDepositoryList = AllocationAction.GetMaterialOfDepositoryList(depositoryId, strWhere);
}
return(materialOfDepositoryList);
}
public int Update(AllocationStockModel stockModel)
{
int num = 0;
if (stockModel.Asid != "")
{
num = AllocationAction.Update(stockModel);
}
return(num);
}
public DataTable GetTreasuryNameByCode(string code)
{
DataTable treasuryNameByCode = new DataTable();
if (code != "")
{
treasuryNameByCode = AllocationAction.GetTreasuryNameByCode(code);
}
return(treasuryNameByCode);
}
public int Insert(SqlTransaction trans, AllocationStockModel stockModel)
{
int num = 0;
if ((stockModel.ACode != "") && (stockModel.SCode != ""))
{
num = AllocationAction.Insert(trans, stockModel);
}
return(num);
}
protected void btnAllDel_ServerClick(object sender, EventArgs e)
{
AllocationAction.DelAllocationStockBill(this.lblAllocationNo.Text);
DataTable dataTable = this.ViewState["DataTable"] as DataTable;
dataTable.Rows.Clear();
this.ViewState["DataTable"] = dataTable;
this.GVMaterialList.DataSource = null;
this.GVMaterialList.DataBind();
}
public int DelAllocationStock(string acode)
{
int num = 0;
if (acode != "")
{
num = AllocationAction.DelAllocationStock(acode);
}
return(num);
}
public Cats.Models.ProjectCodeAllocation convertToEntityModel(AllocationAction allocationAction)
{
return(new Cats.Models.ProjectCodeAllocation
{
SINumberID = allocationAction.ShippingInstructionId,
Amount_FromSI = (int)allocationAction.AllocatedAmount,
ProjectCodeAllocationID = allocationAction.AllocationId,
AlloccationDate = DateTime.Now,
AllocatedBy = 1,
HubAllocationID = allocationAction.HubAllocationID
});
}
public int ExistSameData(string acode, string scode, string corp, decimal price)
{
int num = 0;
if ((acode != "") && (corp != ""))
{
object obj2 = AllocationAction.ExistData(acode, scode, corp, price);
if (obj2 != null)
{
num = int.Parse(obj2.ToString());
}
}
return(num);
}
public DataTable GetTreasuryList(int tflag)
{
DataTable table = new DataTable();
if (!(tflag.ToString() != ""))
{
return(table);
}
if (tflag != -1)
{
return(AllocationAction.GetTreasuryList(tflag.ToString()));
}
return(AllocationAction.GetTreasuryList(null));
}
public string GetUserNameByCode(string code)
{
object userNameByCode = null;
if (code != "")
{
userNameByCode = AllocationAction.GetUserNameByCode(code);
}
if (userNameByCode != null)
{
return(userNameByCode.ToString());
}
return("");
}
protected void btnBind_ServerClick(object sender, EventArgs e)
{
this.UpdateDataSource();
DataTable dataTable = this.ViewState["DataTable"] as DataTable;
DataTable materialOfDepositoryList = AllocationAction.GetMaterialOfDepositoryList(this.HdnSelectOutDepo.Value, this.HdnViewCodeList.Value);
DataColumn dataColumn = new DataColumn("Total", typeof(decimal));
dataColumn.DefaultValue = 0m;
materialOfDepositoryList.Columns.Add(dataColumn);
if (dataTable != null && materialOfDepositoryList != null)
{
if (dataTable.Rows.Count == 1 && string.IsNullOrEmpty(dataTable.Rows[0]["scode"].ToString()))
{
dataTable.Rows.RemoveAt(0);
}
dataTable.PrimaryKey = new DataColumn[]
{
dataTable.Columns["scode"],
dataTable.Columns["sprice"],
dataTable.Columns["corp"]
};
materialOfDepositoryList.PrimaryKey = new DataColumn[]
{
materialOfDepositoryList.Columns["scode"],
materialOfDepositoryList.Columns["sprice"],
materialOfDepositoryList.Columns["corp"]
};
dataTable.Merge(materialOfDepositoryList, true);
this.ViewState["DataTable"] = dataTable;
}
if (dataTable.Rows.Count > 0)
{
this.GVMaterialList.DataSource = dataTable;
this.GVMaterialList.DataBind();
string total = Convert.ToDecimal(dataTable.Compute("SUM(Total)", string.Empty)).ToString("0.000");
GridViewUtility.AddTotalRow(this.GVMaterialList, total, 12);
return;
}
this.GVMaterialList.DataSource = dataTable;
this.GVMaterialList.DataBind();
}
public int InDepositoryConfirm(string acode, string yhdm)
{
DataTable table = AllocationAction.GetAllocation_StockList("sma.acode='" + acode + "' and flowstate=1 and isouta=1 ");
int num = 0;
TreasuryPermitBll bll = new TreasuryPermitBll();
AllocationModel model = new AllocationModel();
model = this.ReturnAllocatonModel(" acode='" + acode + "' ");
if (!bll.IsPermitAccept(model.Acode, yhdm))
{
return(0);
}
if (table.Rows.Count > 0)
{
TreasuryStock stock = new TreasuryStock();
TreasuryStockModel model2 = new TreasuryStockModel();
for (int i = 0; i < table.Rows.Count; i++)
{
model2.corp = table.Rows[i]["corp"].ToString();
model2.incode = acode;
model2.intime = DateTime.Now;
model2.intype = 0;
model2.Type = "A";
model2.isfirst = false;
model2.scode = table.Rows[i]["scode"].ToString();
model2.snumber = decimal.Parse(table.Rows[i]["number"].ToString());
model2.sprice = decimal.Parse(table.Rows[i]["sprice"].ToString());
model2.tcode = table.Rows[i]["tcodeb"].ToString();
model2.tsid = Guid.NewGuid().ToString();
if (stock.Add(model2) <= 0)
{
return(-1);
}
AllocationAction.UpdateState(true, true, acode, "In");
num = 1;
}
}
return(num);
}
public AllocationModel ReturnAllocatonModel(string strWhere)
{
AllocationModel model = new AllocationModel();
DataTable allocationList = new DataTable();
allocationList = AllocationAction.GetAllocationList(strWhere);
if (allocationList.Rows.Count > 0)
{
model.Aid = allocationList.Rows[0]["aid"].ToString();
model.Acode = allocationList.Rows[0]["acode"].ToString();
model.TCodea = allocationList.Rows[0]["tcodea"].ToString();
model.TCodeb = allocationList.Rows[0]["tcodeb"].ToString();
model.IsOutA = Convert.ToBoolean(allocationList.Rows[0]["isouta"].ToString());
model.IsInB = Convert.ToBoolean(allocationList.Rows[0]["isinb"].ToString());
model.Person = allocationList.Rows[0]["person"].ToString();
model.InTime = allocationList.Rows[0]["intime"].ToString();
model.Explain = allocationList.Rows[0]["explain"].ToString();
model.OutAllocationPerson = allocationList.Rows[0]["OutAllocationPerson"].ToString();
model.InAllocationPerson = allocationList.Rows[0]["InAllocationPerson"].ToString();
}
return(model);
}
protected DataTable ReportAlocationDataSource(string strWhere)
{
return(AllocationAction.AllocationReportData(strWhere));
}
public int OutDepositoryConfirm(string acode, string yhdm)
{
DataTable table = AllocationAction.GetAllocation_StockList("sma.acode='" + acode + "' and flowstate=1 ");
DataTable materialDetailsOfDeposity = new DataTable();
int num = 0;
decimal num2 = 0M;
TreasuryPermitBll bll = new TreasuryPermitBll();
for (int i = 0; i < table.Rows.Count; i++)
{
decimal num4 = 0M;
bool flag = bll.IsPermitBool(table.Rows[i]["tcodea"].ToString(), yhdm);
object materialNumberOfDepository = AllocationAction.GetMaterialNumberOfDepository(table.Rows[i]["tcodea"].ToString(), " scode='" + table.Rows[i]["scode"].ToString() + "' and sprice='" + table.Rows[i]["sprice"].ToString() + "' and corp='" + table.Rows[i]["corp"].ToString() + "' ");
if (!flag)
{
num = -3;
break;
}
if (materialNumberOfDepository != null)
{
num4 = decimal.Parse(materialNumberOfDepository.ToString());
}
num2 = decimal.Parse(table.Rows[i]["number"].ToString());
if (num4 < num2)
{
num = -2;
break;
}
}
switch (num)
{
case -2:
case -3:
return(num);
default:
for (int j = 0; j < table.Rows.Count; j++)
{
decimal num6 = 0M;
num6 = decimal.Parse(table.Rows[j]["number"].ToString());
materialDetailsOfDeposity = AllocationAction.GetMaterialDetailsOfDeposity("tcode='" + table.Rows[j]["tcodea"].ToString() + "' and scode='" + table.Rows[j]["scode"].ToString() + "' and sprice='" + table.Rows[j]["sprice"].ToString() + "' and corp='" + table.Rows[j]["corp"].ToString() + "' order by intime asc ");
for (int k = 0; k < materialDetailsOfDeposity.Rows.Count; k++)
{
decimal num8 = 0M;
num8 = decimal.Parse(materialDetailsOfDeposity.Rows[k]["snumber"].ToString());
if (num8 > num6)
{
if (AllocationAction.UpdateNumberOfTreasury(materialDetailsOfDeposity.Rows[k]["tsid"].ToString(), num8 - num6) <= 0)
{
num = -1;
}
else
{
Common2.AlarmMethod(table.Rows[j]["tcodea"].ToString(), table.Rows[j]["scode"].ToString());
}
break;
}
if (num8 == num6)
{
if (new TreasuryStock().Delete(materialDetailsOfDeposity.Rows[k]["tsid"].ToString()) <= 0)
{
num = -1;
}
else
{
Common2.AlarmMethod(table.Rows[j]["tcodea"].ToString(), table.Rows[j]["scode"].ToString());
}
break;
}
if (num8 < num6)
{
if (new TreasuryStock().Delete(materialDetailsOfDeposity.Rows[k]["tsid"].ToString()) <= 0)
{
num = -1;
break;
}
num6 -= num8;
Common2.AlarmMethod(table.Rows[j]["tcodea"].ToString(), table.Rows[j]["scode"].ToString());
}
}
if (num == -1)
{
break;
}
num = 1;
}
break;
}
if (num == 1)
{
AllocationAction.UpdateState(true, false, acode, "Out");
}
return(num);
}
public DataTable GetAllocationStockList(string depositoryId, string strWhere)
{
return(AllocationAction.GetAllocationStockList(depositoryId, strWhere));
}
public DataTable GetAllocationList(string strWhere)
{
return(AllocationAction.GetAllocationList(strWhere));
}