public int AddCAI_OrderCheck(int id)
{
CAI_OrderCheck order = new CAI_OrderCheck();
order.CreatePer = 1;
order.CheckPer = 1;
order.CheckTime = DateTime.Now;
order.CheckRemark = "库存初始化";
VAN_OA.Model.EFrom.tb_EForm eform = new tb_EForm();
int userId = 1;
eform.appPer = userId;
eform.appTime = DateTime.Now;
eform.createPer = 1;
eform.createTime = DateTime.Now;
eform.proId = 21;
eform.state = "不通过";
eform.toPer = 0;
eform.toProsId = 0;
CAI_POCaiService POSer = new CAI_POCaiService();
List <CAI_POCaiView> modelList = POSer.GetListViewCai_POOrders_Cai_POOrderChecks_View(" id=" + id);
List <CAI_OrderChecks> POOrders = new List <CAI_OrderChecks>();
foreach (var model in modelList)
{
CAI_OrderChecks checkModel = new CAI_OrderChecks();
checkModel.Total = model.Total;
checkModel.CaiId = model.POCaiId;
checkModel.CheckGoodId = model.GoodId;
checkModel.CheckNum = model.Num;
checkModel.CheckPrice = model.Price;
checkModel.Good_Model = model.Good_Model;
checkModel.GoodName = model.GoodName;
checkModel.GoodNo = model.GoodNo;
checkModel.GoodSpec = model.GoodSpec;
checkModel.GoodTypeSmName = model.GoodTypeSmName;
checkModel.GoodUnit = model.GoodUnit;
checkModel.GuestName = model.GuestName;
checkModel.POName = model.POName;
checkModel.PONo = model.PONo;
checkModel.SupplierName = model.Supplier;
checkModel.CaiProNo = model.ProNo;
checkModel.QingGou = model.CaiGou;
checkModel.CaiGouPer = model.loginName;
checkModel.CheckLastTruePrice = model.LastTruePrice;
checkModel.GoodAreaNumber = model.GoodAreaNumber;
POOrders.Add(checkModel);
}
CAI_OrderCheckService POOrderSer = new CAI_OrderCheckService();
int MainId = 0;
return(POOrderSer.addTran(order, eform, POOrders, out MainId));
}
private void LastUpdate(int id)
{
CAI_OrderInHousesService ordersSer = new CAI_OrderInHousesService();
List <CAI_OrderInHouses> orders = ordersSer.GetListArray(" 1=1 and CAI_OrderInHouses.id=1");
CAI_OrderChecksService ordersSer111 = new CAI_OrderChecksService();
List <CAI_OrderChecks> orders1111 = ordersSer111.GetListArray(" 1=1 and CAI_OrderChecks.CheckId=" + id);
CAI_OrderCheckService mainSer = new CAI_OrderCheckService();
CAI_OrderCheck pp = mainSer.GetModel(id);
DBHelp.ExeCommand(string.Format(@" update CAI_OrderInHouse SET ChcEkProNo='{0}',pono='{1}',poname='{2}' where id=1;
update CAI_OrderOutHouse set pono='{1}',poname='{2}' where ChcEkProNo='20120000';
update CAI_OrderCheck set status='通过' where id={3} ;update tb_EForm set state='通过',e_LastTime=getdate() where allE_id={3} and proId=21;", pp.ProNo,
orders1111[0].PONo, orders1111[0].POName, id));
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
CAI_POCaiService CaiSer = new CAI_POCaiService();
try
{
objCommand.Parameters.Clear();
foreach (var caiIn in orders)
{
var check = orders1111.Single(t => t.CheckGoodId == caiIn.GooId);
string sql = string.Format(" update CAI_OrderInHouses set OrderCheckIds={1} where ids={0}", caiIn.Ids, check.Ids);
objCommand.CommandText = sql;
objCommand.ExecuteNonQuery();
}
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int id = AddCai();
CAI_POOrderService mainSer = new CAI_POOrderService();
CAI_POOrder pp = mainSer.GetModel(id);
CAI_POOrdersService ordersSer = new CAI_POOrdersService();
List <CAI_POOrders> orders = ordersSer.GetListArray(" 1=1 and CAI_POOrders.id=" + id);
CAI_POCaiService CaiSer = new CAI_POCaiService();
List <CAI_POCai> caiList = CaiSer.GetListArray(" 1=1 and CAI_POCai.id=" + id);
foreach (var cai in caiList)
{
var m = orders_CaiIn.Single(t => t.GooId == cai.GoodId);
cai.Supplier = "本部门（含税）";
cai.SupperPrice = m.GoodPrice;
cai.UpdateUser = "******";
cai.Idea = "";
cai.Num = m.GoodNum;
cai.FinPrice1 = m.GoodPrice;
cai.GoodId = m.GooId;
cai.cbifDefault1 = true;
cai.lastSupplier = "本部门（含税）";
cai.IsHanShui = true;
cai.LastTruePrice = m.GoodPrice;
cai.IfUpdate = true;
}
CAI_POOrderService POOrderSer = new CAI_POOrderService();
POOrderSer.UpdataCai(caiList);
int checkId = AddCAI_OrderCheck(id);
LastUpdate(checkId);
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('成功！');</script>");
}
private void Show()
{
if (!string.IsNullOrEmpty(txtPONo.Text.Trim()))
{
if (CheckPoNO(txtPONo.Text) == false)
{
return;
}
}
string totalWhere;
string sql = getSql(out totalWhere);
if (sql == "")
{
return;
}
List <Petitions> caiList = this.petitionsSer.GetListArray(sql, totalWhere, txtSalesUnit.Text.Trim());
lblTotal.Text = caiList.Sum(t => t.Total).ToString();
AspNetPager1.RecordCount = caiList.Count;
this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
string pono = "";
for (int i = gvList.PageIndex * 10; i < (gvList.PageIndex + 1) * 10; i++)
{
if (caiList.Count - 1 < i)
{
break;
}
pono += string.Format("'{0}',", caiList[i].PoNo);
}
pono = pono.Trim(',');
supplierList = new CAI_POCaiService().GetLastSupplier(pono);
this.gvList.DataSource = caiList;
this.gvList.DataBind();
}
protected void LinkButton1_Click1(object sender, EventArgs e)
{
if (Session["Comm_CGPONo"] != null)
{
CG_POOrder model = POSer.GetSimpListArray(string.Format("and pono='{0}'", Session["Comm_CGPONo"]))[0];
txtAE.Text = model.AE;
txtPONo.Text = model.PONo;
txtGuestName.Text = model.GuestName;
txtName.Text = model.POName;
//var list = POSer.GetOrder_ToInvoice_1(string.Format(" PONo='{0}'", model.PONo));
//if (list.Count > 0)
//{
// txtTotal.Text = (list[0].POTotal - list[0].TuiTotal).ToString();
//}
var supplierList = new CAI_POCaiService().GetLastSupplier(string.Format("'{0}'", model.PONo));
txtSalesUnit.Text = string.Join(",", supplierList.Select(t => t.Supplier).ToArray());
txtTotal.Text = supplierList.Sum(t => t.Total).ToString();
Session["Comm_CGPONo"] = null;
var list = petitionsSer.GetListArray(string.Format(" PoNo='{0}'", txtPONo.Text), "", "");
if (list.Count > 0)
{
var modelPetition = list[0];
lblError.Text = string.Format("该项目已有签呈单，签呈单编号：{0}，签呈单名称:{1}, 签订日期：{2}, 存放位置：{3}",
modelPetition.Number, modelPetition.Name, modelPetition.SignDate.ToString("yyyy-MM-dd"), modelPetition.Local_String);
btnAdd.Enabled = false;
btnUpdate.Enabled = false;
}
else
{
btnAdd.Enabled = true;
btnUpdate.Enabled = true;
lblError.Text = "";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
for (var i = 1; i < 100; i++)
{
ddlL_Month.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
}
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getAllUserByLoginName("");
ddlHandler.DataSource = user;
ddlHandler.DataBind();
ddlHandler.DataTextField = "LoginName";
ddlHandler.DataValueField = "LoginName";
if (base.Request["Id"] != null)
{
this.btnAdd.Visible = false;
Petitions model = this.petitionsSer.GetModel(Convert.ToInt32(base.Request["Id"]));
txtName.Text = model.Name;
this.ddlType.Text = model.Type;
this.lblNumber.Text = model.Number;
this.txtGuestName.Text = model.GuestName;
this.txtSalesUnit.Text = model.SalesUnit;
this.txtSummary.Text = model.Summary;
this.txtTotal.Text = model.Total.ToString();
this.txtSignDate.Text = model.SignDate.ToString();
this.txtSumPages.Text = model.SumPages.ToString();
this.txtSumCount.Text = model.SumCount.ToString();
this.txtBCount.Text = model.BCount.ToString();
this.txtPONo.Text = model.PoNo;
this.txtAE.Text = model.AE;
this.ddlHandler.Text = model.Handler;
this.ddlLocal.Text = model.Local;
this.ddlL_Year.Text = model.L_Year.ToString();
this.ddlL_Month.Text = model.L_Month.ToString();
this.txtRemark.Text = model.Remark;
cbIsRequire.Checked = model.IsRequire;
if (model.IsRequire)
{
lbtnSelectPONo.Visible = false;
}
if (model.IsColse)
{
rabIsColseB.Checked = true;
}
hfYear.Value = model.L_Year.ToString();
var supplierList = new CAI_POCaiService().GetLastSupplier(string.Format("'{0}'", model.PoNo));
txtSalesUnit.Text = string.Join(",", supplierList.Select(t => t.Supplier).ToArray());
txtTotal.Text = supplierList.Sum(t => t.Total).ToString();
}
else
{
ddlHandler.Text = "王汉中";
this.btnUpdate.Visible = false;
}
}
}
private void LoadExcel(string fileAddress)
{
string strConn;
strConn = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + fileAddress + "; Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1'";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable sheetNames = conn.GetOleDbSchemaTable
(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
int allSheets = 0;
foreach (DataRow rowTable in sheetNames.Rows)
{
string sheetName = rowTable["TABLE_NAME"].ToString();
conn = new OleDbConnection(strConn);
conn.Open();
OleDbCommand objCommand = new OleDbCommand(string.Format("select * from [" + sheetName + "]"), conn);
int rowIndex = 1;
BankFlowService bandFlowService = new BankFlowService();
PetitionsService petSer = new PetitionsService();
CG_POOrderService POSer = new CG_POOrderService();
CAI_POCaiService pocaiSer = new CAI_POCaiService();
using (SqlConnection sqlconn = DBHelp.getConn())
{
sqlconn.Open();
SqlCommand sqlCommand = sqlconn.CreateCommand();
using (OleDbDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
//if (rowIndex > 1)
//{
// Petitions model = new Petitions();
// model.Number = dataReader[0].ToString();
// model.Type = dataReader[1].ToString();
// model.OldIndex = dataReader[2].ToString();
// var ojb = dataReader[3];
// if (ojb != null && ojb != DBNull.Value)
// {
// model.SignDate = Convert.ToDateTime(ojb);
// }
// model.PoNo = dataReader[4].ToString();
// model.Summary = dataReader[5].ToString();
// ojb = dataReader[6];
// if (ojb != null && ojb != DBNull.Value)
// {
// model.SumPages = Convert.ToInt32(ojb);
// }
// model.Local = dataReader[7].ToString();
// model.L_Year = Convert.ToInt32(dataReader[8]);
// model.L_Month = Convert.ToInt32(dataReader[9]);
// model.Remark = dataReader[10].ToString();
// model.SumCount = 1;
// model.BCount = 1;
// model.Handler = "王汉中";
// var poList = POSer.GetSimpListArray(string.Format("and pono='{0}'", model.PoNo), sqlCommand);
// if (poList.Count > 0)
// {
// CG_POOrder poorderModel = poList[0];
// model.AE = poorderModel.AE;
// model.GuestName = poorderModel.GuestName;
// model.Name = poorderModel.POName;
// //var supplierList = pocaiSer.GetLastSupplier(string.Format("'{0}'", model.PoNo), sqlCommand);
// //model.SalesUnit = string.Join(",", supplierList.Select(t => t.Supplier).ToArray());
// //model.Total = supplierList.Sum(t => t.Total);
// }
// petSer.Add(model,sqlCommand);
//}
if (rowIndex > 8)
{
BankFlow model = new BankFlow();
model.TransactionType = dataReader[0].ToString();
if (model.TransactionType == "")
{
continue;
}
model.BusinessType = dataReader[1].ToString();
model.PayerAccountBank = dataReader[3].ToString();
model.DebitAccountNo = dataReader[4].ToString();
model.OutPayerName = dataReader[5].ToString();
model.BeneficiaryAccountBank = dataReader[7].ToString();
model.PayeeAccountNumber = dataReader[8].ToString();
model.InPayeeName = dataReader[9].ToString();
DateTime dt = DateTime.ParseExact(dataReader[10].ToString(), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
model.TransactionDate = Convert.ToDateTime(dt.ToString("yyyy-MM-dd") + " " + dataReader[11]);
model.TradeCurrency = dataReader[12].ToString();
model.TradeAmount = Convert.ToDecimal(dataReader[13]);
model.AfterTransactionBalance = Convert.ToDecimal(dataReader[14]);
model.TransactionReferenceNumber = dataReader[17].ToString();
model.VoucherType = dataReader[20].ToString();
model.Reference = dataReader[23].ToString();
model.Purpose = dataReader[24].ToString();
model.Remark = dataReader[25].ToString();
model.Remarks = dataReader[26].ToString();
//判断是否重复
string sql = string.Format("SELECT top 1 ID FROM [BankFlow] WHERE TransactionReferenceNumber='{0}'", model.TransactionReferenceNumber);
sqlCommand.CommandText = sql;
var resultId = sqlCommand.ExecuteScalar();
if (!(resultId is DBNull) && resultId != null)
{
model.Id = Convert.ToInt32(resultId);
bandFlowService.Update(model, sqlCommand);
}
else
{
bandFlowService.Add(model, sqlCommand);
}
}
rowIndex++;
}
}
sqlconn.Close();
}
}
}
public bool FormCheck()
{
#region 设置自己要判断的信息
if (txtCheckPer.Text == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写检验人！');</script>");
txtCheckPer.Focus();
return(false);
}
if (txtCheckTime.Text == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写检验时间！');</script>");
txtCheckTime.Focus();
return(false);
}
else
{
if (CommHelp.VerifesToDateTime(txtCheckTime.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('检验时间 格式错误！');</script>");
return(false);
}
}
try
{
Convert.ToDateTime(txtCheckTime.Text);
}
catch (Exception)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写检验时间有误！');</script>");
txtCheckTime.Focus();
return(false);
}
if (ddlPers.Visible == true && ddlPers.SelectedItem == null)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择下一步审核人！');</script>");
ddlPers.Focus();
return(false);
}
if (DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text)) == null)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写申请用户不存在！');</script>");
return(false);
}
if (DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtCheckPer.Text)) == null)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写检验人不存在！');</script>");
return(false);
}
#endregion
if (Request["allE_id"] == null)
{
List <CAI_OrderChecks> POOrders = Session["Orders"] as List <CAI_OrderChecks>;
if (POOrders == null || POOrders.Count <= 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请添加明显信息！');</script>");
return(false);
}
var mycaiIds = new StringBuilder();
foreach (var m in POOrders)
{
mycaiIds.AppendFormat("{0},", m.CaiId);
}
if (mycaiIds.ToString() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请添加明细！');</script>");
return(false);
}
var ids = mycaiIds.ToString().Substring(0, mycaiIds.ToString().Length - 1);
//--在创建/编辑 预付单时 判断是否已经有入库记录(包含正在执行的单子)
string checkSql = string.Format(@"select COUNT(*) from TB_SupplierAdvancePayment left join TB_SupplierAdvancePayments on
TB_SupplierAdvancePayment.Id=TB_SupplierAdvancePayments.Id where Status='执行中'
and CaiIds in ({0})", ids);//--增加采购订单的ID ( and CaiId=?)
var errorText = new StringBuilder();
var count = DBHelp.ExeScalar(checkSql);
if (count != null && Convert.ToInt32(count) > 0)
{
errorText.Append("列表中采购数据，存在正在执行中的预付款单，请先将对应预付款单审批通过！");
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('" + errorText.ToString() + "');</script>");
return(false);
}
Hashtable ht = new Hashtable();
Hashtable htSupplier = new Hashtable();
foreach (var model in POOrders)
{
string key = model.CheckGoodId.ToString() + model.CaiProNo;
if (!ht.Contains(key))
{
ht.Add(key, null);
}
else
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('单号[{3}]-商品[{0}]\规格[{1}]\型号[{2}],信息重复！');</script>", model.GoodName, model.GoodSpec, model.Good_Model, model.CaiProNo));
return(false);
}
string aa = model.SupplierName + model.PONo + model.POName + model.CaiGouPer;
if (!htSupplier.Contains(aa))
{
if ((!model.PONo.Contains("KC")) && new CG_POOrderService().ExistPONO(model.PONo) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目信息不存在！');</script>");
return(false);
}
htSupplier.Add(aa, null);
if (htSupplier.Keys.Count > 1)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('检验单中 项目单号，项目名称,供应商,采购人必选完全一样！');</script>"));
return(false);
}
}
}
CAI_POCaiService POSer = new CAI_POCaiService();
for (int i = 0; i < gvList.Rows.Count; i++)
{
TextBox txtNum = gvList.Rows[i].FindControl("txtNum") as TextBox;
if (txtNum != null)
{
if (CommHelp.VerifesToNum(txtNum.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数量 格式错误！');</script>");
return(false);
}
POOrders[i].CheckNum = Convert.ToDecimal(txtNum.Text);
}
var model = POOrders[i];
if (model.CheckNum <= 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('商品[{0}]\规格[{1}]\型号[{2}],数量必须大于0！');</script>", model.GoodName, model.GoodSpec, model.Good_Model));
return(false);
}
if (model.CheckPrice < 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('商品[{0}]\规格[{1}]\型号[{2}],价格必须大于等于0！');</script>", model.GoodName, model.GoodSpec, model.Good_Model));
return(false);
}
string sql = string.Format(" 1=1 and Ids={0}", model.CaiId);
List <CAI_POCaiView> cars = POSer.GetListViewCai_POOrders_Cai_POOrderChecks_View(sql);
if (cars.Count <= 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('单号[{3}]-商品[{0}]\规格[{1}]\型号[{2}],在项目订单[{3}]中不存在！');</script>", model.GoodName, model.GoodSpec, model.Good_Model, model.PONo));
return(false);
}
if (model.CheckNum > cars[0].ResultNum)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('单号[{3}]-商品[{0}]\规格[{1}]\型号[{2}],检查数量剩余[{3}]！');</script>", model.GoodName, model.GoodSpec, model.Good_Model, cars[0].ResultNum));
return(false);
}
}
Session["Orders"] = POOrders;
}
else
{
List <CAI_OrderChecks> POOrders = Session["Orders"] as List <CAI_OrderChecks>;
CAI_POCaiService POSer = new CAI_POCaiService();
for (int i = 0; i < gvList.Rows.Count; i++)
{
TextBox txtNum = gvList.Rows[i].FindControl("txtNum") as TextBox;
if (txtNum != null)
{
if (CommHelp.VerifesToNum(txtNum.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数量 格式错误！');</script>");
return(false);
}
POOrders[i].CheckNum = Convert.ToDecimal(txtNum.Text);
}
var model = POOrders[i];
if (model.CheckNum <= 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('商品[{0}]\规格[{1}]\型号[{2}],数量必须大于0！');</script>", model.GoodName, model.GoodSpec, model.Good_Model));
return(false);
}
if (model.CheckPrice < 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('商品[{0}]\规格[{1}]\型号[{2}],价格必须大于等于0！');</script>", model.GoodName, model.GoodSpec, model.Good_Model));
return(false);
}
if (i == 0 && (!model.PONo.Contains("KC")) && new CG_POOrderService().ExistPONO(model.PONo) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目信息不存在！');</script>");
return(false);
}
//查询订单原来的数量
string oldString = string.Format(@"select isnull(Num,0)-ISNULL(totalOrderNum,0) as ResultNum from CAI_POCai
left join CAI_POOrder on CAI_POCai.Id=CAI_POOrder.Id
left join
(
select CaiId,SUM(CheckNum) as totalOrderNum from CAI_OrderChecks left join CAI_OrderCheck on
CAI_OrderCheck.id=CAI_OrderChecks.CheckId
where CaiId<>0 and status<>'不通过' and CAI_OrderChecks.Ids<>{0}
group by CaiId
)
as newtable on CAI_POCai.Ids=newtable.CaiId where (CAI_POCai.Num>newtable.totalOrderNum or totalOrderNum is null)
and status='通过' and Ids={1}", model.Ids, model.CaiId);
var oldNum = DBHelp.ExeScalar(oldString);
if (oldNum is DBNull)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('单号[{3}]-商品[{0}]\规格[{1}]\型号[{2}],在项目订单[{3}]中不存在！');</script>", model.GoodName, model.GoodSpec, model.Good_Model, model.PONo));
return(false);
}
if (model.CheckNum > Convert.ToDecimal(oldNum))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('单号[{3}]-商品[{0}]\规格[{1}]\型号[{2}],检查数量剩余[{3}]！');</script>", model.GoodName, model.GoodSpec, model.Good_Model, oldNum));
return(false);
}
}
Session["Orders"] = POOrders;
}
if (ddlResult.SelectedItem != null && ddlResult.SelectedItem.Text == "通过")
{
List <CAI_OrderChecks> POOrders = Session["Orders"] as List <CAI_OrderChecks>;
//判断是否为特殊商品 并查询库存是否有库存
TB_HouseGoodsService goodHouseSer = new TB_HouseGoodsService();
CAI_OrderCheckService checkSer = new CAI_OrderCheckService();
foreach (var m in POOrders)
{
if (goodHouseSer.CheckGoodInHouse(m.CheckGoodId))
{
string mess = checkSer.GetPONoInfo(m.CheckGoodId, m.GoodNo, m.GoodName, m.GoodTypeSmName, m.GoodSpec);
if (mess == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format(@"<script>alert('数据异常！');</script>"));
return(false);
}
base.ClientScript.RegisterStartupScript(base.GetType(), null,
string.Format(@"<script>alert('{0}！');</script>",
mess));
return(false);
}
}
}
//判断有没有设置默认仓库
if (ddlPers.Visible == false)
{
string sql = "select count(*) from TB_HouseInfo where IfDefault=1";
if (Convert.ToInt32(DBHelp.ExeScalar(sql)) != 1)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "默认仓库设置错误！请检查");
return(false);
}
}
return(true);
}
