private void dgvData_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e) { if (e.Row.Index >= 0) { DataGridViewRow row = dgvData.Rows[e.Row.Index]; if ("".Equals(CConvert.ToString(row.Cells["SLIP_NUMBER"].Value))) { row.Selected = false; } } }
private void cboReturn_SelectedIndexChanged(object sender, EventArgs e) { if (CConvert.ToString(CConstant.PURCHASE_RETURN).Equals(cboReturn.SelectedValue)) { txtPurchaseNumber.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); } else if (CConvert.ToString(CConstant.PRODUCE_RETURN).Equals(cboReturn.SelectedValue)) { txtPurchaseNumber.BackColor = SystemColors.Info; } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSaveNames_Click(object sender, EventArgs e) { Button btn = (Button)sender; TextBox txt = (TextBox)btn.Parent.Controls.Find("txt" + CConvert.ToString(btn.Tag), true)[0]; if (!bCommon.ExistsBaseNames(CConvert.ToString(btn.Tag), txt.Text.Trim())) { bCommon.SaveBaseNmaes(CConvert.ToString(btn.Tag), txt.Text.Trim()); CCacheData.BaseNames = null; } }
//添加新行 private void NewRow() { foreach (DataGridViewRow dgvr in dgvData.Rows) { if (string.IsNullOrEmpty(CConvert.ToString(dgvr.Cells["CODE"].Value))) { return; } } dgvData.Rows.Add(1); }
private void btnCalculate_Click(object sender, EventArgs e) { if (CalculateCheck()) { BAlloation bAlloation = new BAlloation(); decimal alloationQuantity = bAlloation.GetAlloationQuantity(txtWarehouse.Text.Trim(), txtProduct.Text.Trim()); BaseStockTable stock = new BaseStockTable(); stock = bPurchaseOrder.GetStockModel(txtWarehouse.Text.Trim(), txtProduct.Text.Trim()); txtNoAlloation.Text = CConvert.ToString(stock.QUANTITY - alloationQuantity); } }
/// <summary> /// 获取新闻列表信息 /// </summary> /// <returns></returns> private Hashtable GetQuesList(HttpContext context) { Hashtable htRet = new Hashtable(); Hashtable rowData = new Hashtable(); try { FastReadServer.admin.UserInfo user = (FastReadServer.admin.UserInfo)context.Session[FastReadServer.admin.CConst.CSession.C_UserInfoKey]; if (user == null || user.UserId == "") { htRet["msg"] = "用户信息超时,请重新登录!"; htRet["ok"] = false; return(htRet); } string sTestId = CConvert.ToString(context.Request["id"]); string sQType = CConvert.ToString(context.Request["qt"]); DBIndex dbm = new DBIndex(); DataSet ds = dbm.GetQuesList(sTestId, sQType); if (ds.Tables[0].Rows.Count == 0) { htRet["ok"] = true; htRet["cnt"] = 0; htRet["msg"] = "无数据!"; } else { ArrayList lst = new ArrayList(); foreach (DataRow dr in ds.Tables[0].Rows) { Hashtable htItem = new Hashtable(); foreach (DataColumn dc in ds.Tables[0].Columns) { htItem[dc.ColumnName] = CConvert.ToString(dr[dc.ColumnName]); } lst.Add(htItem); } htRet["ok"] = true; htRet["lst"] = lst; htRet["cnt"] = lst.Count; } } catch (Exception ex) { htRet["err"] = true; htRet["msg"] = "获取轮播信息失败!" + ex.Message; } return(htRet); }
private void dgvData_CellValidated(object sender, DataGridViewCellEventArgs e) { try { DataGridViewRow dgvr = dgvData.Rows[e.RowIndex]; decimal UN_PAYMENT_AMOUNT = CConvert.ToDecimal(dgvr.Cells["UN_PAYMENT_AMOUNT"].Value); if (e.ColumnIndex == dgvData.Columns["DEPOSIT_AMOUNT"].Index) { if (CConvert.ToDecimal(dgvr.Cells["DEPOSIT_AMOUNT"].Value) <= UN_PAYMENT_AMOUNT && (CConvert.ToDecimal(dgvr.Cells["DEPOSIT_AMOUNT"].Value) + CConvert.ToDecimal(dgvr.Cells["OTHER_AMOUNT"].Value)) <= UN_PAYMENT_AMOUNT) { Calculate(); } else { MessageBox.Show("预付款金额不能大于未付金额,\r\n或预付款金额与付款金额之和不能大于未付金额", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); dgvr.Cells["DEPOSIT_AMOUNT"].Value = "0"; dgvr.Cells["DEPOSIT_AMOUNT"].Selected = true; } } else if (e.ColumnIndex == dgvData.Columns["OTHER_AMOUNT"].Index) { if (CConvert.ToDecimal(dgvr.Cells["OTHER_AMOUNT"].Value) <= UN_PAYMENT_AMOUNT && (CConvert.ToDecimal(dgvr.Cells["DEPOSIT_AMOUNT"].Value) + CConvert.ToDecimal(dgvr.Cells["OTHER_AMOUNT"].Value)) <= UN_PAYMENT_AMOUNT) { Calculate(); } else { MessageBox.Show("付款金额不能大于未付金额,\r\n或预付款金额与付款金额之和不能大于未付金额", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); dgvr.Cells["OTHER_AMOUNT"].Value = "0"; dgvr.Cells["OTHER_AMOUNT"].Selected = true; } } else if (e.ColumnIndex == dgvData.Columns["SLIP_DATE"].Index) { string slipDate = CConvert.ToString(dgvr.Cells["SLIP_DATE"].Value); if (slipDate != "") { DateTime dTime = DateTime.Now; try { dTime = DateTime.Parse(slipDate); } catch { MessageBox.Show("请输入正确的付款日期。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } dgvr.Cells["SLIP_DATE"].Value = dTime.ToString("yyyy-MM-dd"); } } } catch { } }
/// <summary> /// 数据查询,绑定 /// </summary> private void BindData(int currentPage) { string strWhere = GetConduction(); DataSet ds = bProductBuild.GetBilldList(strWhere, "", (currentPage - 1) * PageSize + 1, currentPage * PageSize); dgvData.Rows.Clear(); foreach (DataRow rows in ds.Tables[0].Rows) { int currentRowIndex = dgvData.Rows.Add(1); DataGridViewRow row = dgvData.Rows[currentRowIndex]; row.Cells[1].Selected = false; row.Cells["No"].Value = rows["Row"]; row.Cells["PARTS_CODE"].Value = rows["PRODUCT_PART_CODE"]; row.Cells["MIN_QUANTITY"].Value = rows["QUANTITY"]; row.Cells["PARTS_NAME"].Value = rows["PRODUCT_PART_NAME"]; row.Cells["SPEC"].Value = rows["SPEC"]; row.Cells["UNIT_CODE"].Value = rows["UNIT_CODE"]; row.Cells["UNIT_NAME"].Value = rows["UNIT_NAME"]; //BAlloation bAlloation = new BAlloation(); decimal alloationQuantity = bAlloation.GetAlloationQuantity(txtWarehouse.Text.Trim(), CConvert.ToString(rows["PRODUCT_PART_CODE"])); BaseStockTable stock = new BaseStockTable(); stock = bPurchaseOrder.GetStockModel(txtWarehouse.Text.Trim(), CConvert.ToString(rows["PRODUCT_PART_CODE"])); row.Cells["NO_ALLOATION"].Value = stock.QUANTITY - alloationQuantity; row.Cells["PURCHASE_QUANTITY"].Value = CConvert.ToDecimal(rows["QUANTITY"]) * CConvert.ToDecimal(txtQuantity.Text.Trim()); if (CConvert.ToDecimal(row.Cells["NO_ALLOATION"].Value) >= CConvert.ToDecimal(row.Cells["PURCHASE_QUANTITY"].Value)) { row.Cells["STATUE_FLAG"].Value = "OK"; } else { row.Cells["STATUE_FLAG"].Value = "NG"; } double p = Convert.ToDouble(CConvert.ToDecimal(row.Cells["NO_ALLOATION"].Value) / CConvert.ToDecimal(row.Cells["MIN_QUANTITY"].Value)); int old = (int)Math.Floor(p); if (CConvert.ToInt32(rows["Row"]) == 1) { possible = old; } else if (possible >= old) { possible = old; } } if (ds.Tables[0].Rows.Count < PageSize * currentPage) { dgvData.Rows.Add(PageSize - ds.Tables[0].Rows.Count); } }
/// <summary> /// 修改密码 /// </summary> /// <returns></returns> private Hashtable ChangePwd(HttpContext context) { Hashtable htRet = new Hashtable(); try { string sOldPwd = CConvert.ToString(context.Request["opwd"]).Trim(); string sNewPwd = CConvert.ToString(context.Request["npwd"]).Trim(); FastReadServer.admin.UserInfo user = (FastReadServer.admin.UserInfo)context.Session[FastReadServer.admin.CConst.CSession.C_UserInfoKey]; if (user == null || user.UserId == "") { htRet["msg"] = "用户信息超时,请重新登录!"; htRet["ok"] = false; return(htRet); } string sUid = user.UserId; DBIndex dbm = new DBIndex(); DataSet ds = new DBLogin().GetUserInfoById(sUid); if (ds.Tables[0].Rows.Count == 0) { htRet["msg"] = "用户不存在!"; htRet["ok"] = false; return(htRet); } if (System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(sOldPwd, "MD5") != CConvert.ToString(ds.Tables[0].Rows[0]["pwd"])) { htRet["msg"] = "旧密码不正确!"; htRet["ok"] = false; return(htRet); } int iRet = dbm.ChangePwd(sUid, System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(sNewPwd, "MD5")); if (iRet == 0) { htRet["msg"] = "服务器异常,请联系管理员!"; htRet["ok"] = false; return(htRet); } else { htRet["ok"] = true; } } catch (Exception ex) { htRet["ok"] = false; htRet["msg"] = "处理失败!" + ex.Message; } return(htRet); }
/// <summary> /// 获取新闻列表信息 /// </summary> /// <returns></returns> private Hashtable GetUpdateLog(HttpContext context) { Hashtable htRet = new Hashtable(); Hashtable rowData = new Hashtable(); try { FastReadServer.admin.UserInfo user = (FastReadServer.admin.UserInfo)context.Session[FastReadServer.admin.CConst.CSession.C_UserInfoKey]; if (user == null || user.UserId == "") { htRet["msg"] = "用户信息超时,请重新登录!"; htRet["ok"] = false; return(htRet); } string sVerCode = CConvert.ToString(context.Request["vercode"]); int iLimit = CConvert.ToInt32(context.Request["limit"]); int iPage = CConvert.ToInt32(context.Request["page"]); int allRows = 0; DBIndex dbm = new DBIndex(); DataSet ds = dbm.GetVercodeUpdateLog(sVerCode, iPage, iLimit, ref allRows); if (ds.Tables[0].Rows.Count == 0) { htRet["ok"] = true; htRet["cnt"] = 0; htRet["msg"] = "无数据!"; } else { ArrayList lst = new ArrayList(); foreach (DataRow dr in ds.Tables[0].Rows) { Hashtable htItem = new Hashtable(); htItem["code"] = CConvert.ToString(dr["code"]); htItem["last_time"] = CConvert.ToString(dr["last_time"]); lst.Add(htItem); } htRet["ok"] = true; htRet["lst"] = lst; htRet["cnt"] = allRows; htRet["curpage"] = iPage; } } catch (Exception ex) { htRet["err"] = true; htRet["msg"] = "获取轮播信息失败!" + ex.Message; } return(htRet); }
/// <summary> /// 根据编号获得常用输入内容 /// </summary> /// <param name="code"></param> /// <returns></returns> public static string[] GetBaseNamesData(string code) { DataRow[] rows = CCacheData.BaseNames.Select("CODE='" + code + "'"); string[] str = new string[rows.Length]; int i = 0; foreach (DataRow row in rows) { str[i++] = CConvert.ToString(row["NAME"]); } return(str); }
/// <summary> /// 数据库表字段发生变化时 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cboBaseTable_SelectedIndexChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(CConvert.ToString(cboBaseTable.SelectedValue))) { _currentTableStruct = bCommon.GetTableStruct(CConvert.ToString(cboBaseTable.SelectedValue)).Tables[0]; } else { _currentTableStruct = new DataTable(); } DataBind(); }
private void Calculate() { decimal totalAmount = 0; foreach (DataGridViewRow row in dgvData.Rows) { decimal depositAmount = CConvert.ToDecimal(CConvert.ToString(row.Cells["DEPOSIT_AMOUNT"].Value)); decimal otherAmount = CConvert.ToDecimal(CConvert.ToString(row.Cells["OTHER_AMOUNT"].Value)); totalAmount = totalAmount + depositAmount + otherAmount; } txtTotalNoPayment.Text = totalAmount.ToString(); }
private void Pic_Click(object sender, EventArgs e) { PictureBox pic = (PictureBox)sender; Control[] control = this.Controls.Find(pic.Name.Replace("Frm", "LBL") + CConvert.ToString(_pic.Tag, 2), true); //调用父窗体的ParentShowForm()方法 if ((this.MdiParent != null) && (this.MdiParent is CZZD.ERP.Main.IMdiParent)) { (this.MdiParent as CZZD.ERP.Main.IMdiParent).ParentShowForm("WinUI", pic.Name, control[0].Text, pic.Tag.ToString()); } }
private void dgvData_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == dgvData.Columns["BtnProduct"].Index) { FrmMasterSearch frm = new FrmMasterSearch("PRODUCT", ""); if (frm.ShowDialog(this) == DialogResult.OK) { if (frm.BaseMasterTable != null) { DataGridViewRow dr = dgvData.Rows[e.RowIndex]; string code = frm.BaseMasterTable.Code; BaseProductTable productTable = bProduct.GetModel(code); BaseStockTable stock = bStock.GetModel(txtWarehouseCode.Text.Trim(), productTable.CODE); if (productTable != null) { dr.Cells["PRODUCT_CODE"].Value = productTable.CODE; dr.Cells["PRODUCT_NAME"].Value = productTable.NAME; dr.Cells["SPEC"].Value = productTable.SPEC + " " + productTable.MODEL_NUMBER; if (stock != null) { dr.Cells["QUANTITY"].Value = CConvert.ToString(stock.QUANTITY); } else { dr.Cells["QUANTITY"].Value = 0; } if (!string.IsNullOrEmpty(productTable.BASIC_UNIT_CODE)) { dr.Cells["UNIT_NAME"].Value = bCommon.GetBaseMaster("UNIT", productTable.BASIC_UNIT_CODE).Name; dr.Cells["UNIT_CODE"].Value = productTable.BASIC_UNIT_CODE; } dr.Cells["SANCTION_NUMBER"].Value = "1"; //DataGridViewComboBoxColumn cbo = (DataGridViewComboBoxColumn)this.dgvData.Columns["REASON"]; //MessageBox.Show(cbo.Items[0]); } else { MessageBox.Show("商品不存在.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); dr.Cells["QUANTITY"].Value = "0"; dr.Cells["CODE"].Selected = true; } } } frm.Dispose(); } } catch (Exception ex) { } }
/// <summary> /// /// </summary> private void dgvData_CellValidated(object sender, DataGridViewCellEventArgs e) { try { DataGridViewRow dr = dgvData.Rows[e.RowIndex]; if (e.ColumnIndex == dgvData.Columns["PURCHASE_ORDER_SLIP_NUMBER"].Index) { string purchaseOrderSlipNumber = CConvert.ToString(dr.Cells["PURCHASE_ORDER_SLIP_NUMBER"].Value).Trim(); string no = CConvert.ToString(dr.Cells["NO"].Value).Trim(); if (purchaseOrderSlipNumber != "") { BllPurchaseOrderTable purchaseOrderTable = bPurchaseOrder.GetModel(purchaseOrderSlipNumber); if (purchaseOrderTable != null) { if (!IsExist(purchaseOrderSlipNumber, no)) { dr.Cells["PURCHASE_ORDER_SLIP_NUMBER"].Value = purchaseOrderTable.SLIP_NUMBER; dr.Cells["PURCHASE_ORDER_SLIP_DATE"].Value = CConvert.ToDateTime(purchaseOrderTable.SLIP_DATE).ToString("yyyy-MM-dd"); dr.Cells["TOTAL_AMOUNT"].Value = purchaseOrderTable.TOTAL_AMOUNT; dr.Cells["ARR_AMOUNT"].Value = bDepositArr.GetArrAmount(purchaseOrderTable.SLIP_NUMBER); } } else { MessageBox.Show("订单编号不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); dr.Cells["PURCHASE_ORDER_SLIP_NUMBER"].Value = ""; dr.Cells["PURCHASE_ORDER_SLIP_DATE"].Value = ""; dr.Cells["TOTAL_AMOUNT"].Value = ""; dr.Cells["ARR_AMOUNT"].Value = "0"; dr.Cells["AMOUNT"].Value = ""; } } } else if (e.ColumnIndex == dgvData.Columns["AMOUNT"].Index) { string amount = CConvert.ToString(dr.Cells["AMOUNT"].Value); if (amount == "") { dr.Cells["AMOUNT"].Value = 0; } else { dr.Cells["AMOUNT"].Value = CConvert.ToDecimal(amount); } } } catch (Exception ex) { Logger.Error("CellValidated error!", ex); } }
/// <summary> /// 获取在线咨询列表信息 /// </summary> /// <returns></returns> private Hashtable GetQaList(HttpContext context) { Hashtable htRet = new Hashtable(); Hashtable rowData = new Hashtable(); try { int iLimit = CConvert.ToInt32(context.Request["limit"]); int iPage = CConvert.ToInt32(context.Request["page"]); string sContent = CConvert.ToString(context.Request["sname"]); string sAll = CConvert.ToString(context.Request["all"]); int allRows = 0; DBIndex dbm = new DBIndex(); DataSet ds = dbm.GetQAList(sAll, sContent, iPage, iLimit, ref allRows); if (ds.Tables[0].Rows.Count == 0) { htRet["ok"] = true; htRet["cnt"] = 0; htRet["msg"] = "无数据!"; } else { ArrayList lst = new ArrayList(); foreach (DataRow dr in ds.Tables[0].Rows) { Hashtable htItem = new Hashtable(); htItem["nickname"] = CConvert.ToString(dr["nickname"]); htItem["problem"] = (CConvert.ToString(dr["problem"])); htItem["time"] = CConvert.ToString(dr["time"]); htItem["id"] = CConvert.ToString(dr["id"]); htItem["state"] = CConvert.ToString(dr["state"]); htItem["reply"] = (CConvert.ToString(dr["reply"])); htItem["replytime"] = CConvert.ToString(dr["replytime"]); lst.Add(htItem); } htRet["ok"] = true; htRet["lst"] = lst; htRet["cnt"] = allRows; htRet["curpage"] = iPage; } } catch (Exception ex) { htRet["err"] = true; htRet["msg"] = "获取轮播信息失败!" + ex.Message; } return(htRet); }
/// <summary> /// DataGridView 行添加 /// </summary> private void btnAddRow_Click(object sender, EventArgs e) { foreach (DataGridViewRow dr in dgvData.Rows) { if ("".Equals(CConvert.ToString(dr.Cells["PURCHASE_ORDER_SLIP_NUMBER"].Value).Trim())) { dr.Cells["PURCHASE_ORDER_SLIP_NUMBER"].Selected = true; return; } } int currentRowIndex = dgvData.Rows.Add(1); DataGridViewRow row = dgvData.Rows[currentRowIndex]; }
/// <summary> /// 获得指定类型的目录 /// </summary> /// <param name="type"></param> /// <returns></returns> public static string GetAttacheDirectory(string type) { string ret = ""; foreach (DataRow dr in CCacheData.AttacheDirectory.Rows) { if (type.Equals(dr["CODE"])) { ret = CConvert.ToString(dr["PROPERT1"]); } } return(ret); }
/// <summary> /// 数据绑定 /// </summary> /// <param name="dgv"></param> /// <param name="code"></param> private void BindData(DataGridView dgv, string code) { DataTable dtData = bProduct.GetList(" GROUP_CODE='" + code + "' AND SELL_LOCATION=1 ").Tables[0]; if (dtData != null && dtData.Rows.Count > 0) { foreach (DataRow row in dtData.Rows) { object[] obj = { false, row["CODE"], row["NAME"], CConvert.ToString(row["SPEC"]) + " " + CConvert.ToString(row["MODEL_NUMBER"]), 1 }; dgv.Rows.Add(obj); } } }
/// <summary> /// 获取轮播图片信息 /// </summary> /// <returns></returns> private Hashtable CheckVerCode(HttpContext context) { Hashtable htRet = new Hashtable(); Hashtable rowData = new Hashtable(); try { DBIndex dbm = new DBIndex(); string sVerCode = CConvert.ToString(context.Request["vercode"]); string sMac = CConvert.ToString(context.Request["mac"]); DataSet ds = dbm.getVercodeInfoByCode(sVerCode); if (ds.Tables[0].Rows.Count == 0) { htRet["msg"] = "授权码不正确!"; htRet["ok"] = false; } else { DataRow dr = ds.Tables[0].Rows[0]; if (CConvert.ToString(dr["mac"]) == "") { if (dbm.UpdateMac(sVerCode, sMac) != 1) { htRet["msg"] = "授权码不正确!"; htRet["ok"] = false; return(htRet); } } else { if (CConvert.ToString(dr["mac"]) != sMac) { htRet["msg"] = "授权码不正确!"; htRet["ok"] = false; return(htRet); } } htRet["ok"] = true; } } catch (Exception ex) { htRet["ok"] = false; htRet["msg"] = "获取轮播信息失败!" + ex.Message; } return(htRet); }
protected bool CheckRoles(DataTable rolesDt, string _namespace, string _frmName, string _title, string _tag) { bool roles = false; foreach (DataRow dr in rolesDt.Rows) { if (_frmName.Equals(dr["CLASS_NAME"]) && _tag.Equals(CConvert.ToString(dr["TAG"]))) { roles = true; break; } } return(roles); }
private void btnCustomer_Click(object sender, EventArgs e) { FrmMasterSearch frm = new FrmMasterSearch("CUSTOMER", ""); if (frm.ShowDialog(this) == DialogResult.OK) { if (frm.BaseMasterTable != null) { txtCustomerCode.Text = frm.BaseMasterTable.Code; txtCustomerName.Text = frm.BaseMasterTable.Name; } } frm.Dispose(); txtBalance.Text = CConvert.ToString(GetCustomerDepositBlanace(txtCustomerCode.Text.Trim())); }
/// <summary> /// 行点击 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvData_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { DataGridViewRow dgvr = dgvData.Rows[e.RowIndex]; if (e.ColumnIndex == dgvData.Columns["REF_STOCK"].Index) { string productCode = CConvert.ToString(dgvr.Cells["PRODUCT_CODE"].Value); FrmStockSearch frm = new FrmStockSearch("", productCode); frm.ShowDialog(this); frm.Dispose(); } } }
/// <summary> /// 详细操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { if (dgvData.SelectedRows.Count > 0) { DataGridViewRow dr = dgvData.SelectedRows[0]; historySlipNumber = CConvert.ToString(dr.Cells["HISTORY_NUMBER"].Value); _dialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("请选择操作行!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnReceiptCancel_Click(object sender, EventArgs e) { if (isSearch && dgvData.SelectedRows.Count > 0) { DataGridViewRow dgvr = dgvData.SelectedRows[0]; if (MessageBox.Show("确定要入库取消吗?", this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { //if (CConvert.ToInt32(dgvr.Cells["STATUS_FLAG"].Value) == CConstant.NORMAL_STATUS) //{ // MessageBox.Show("采购发票已开,不能进行入库取消。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} try { string slipNumber = CConvert.ToString(dgvData.SelectedRows[0].Cells["SLIP_NUMBER"].Value); int flag = CConvert.ToInt32(dgvData.SelectedRows[0].Cells["RECEIPT_FLAG"].Value); if (!string.IsNullOrEmpty(slipNumber)) { int i = 0; if (flag == 1) { i = bRerceipt.UnReceipt(slipNumber); } else { i = bRerceipt.DeleteOtherReceipt(slipNumber); } if (i < 0) { MessageBox.Show("入库订单取消失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { BindData(this.pgControl.GetCurrentPage()); MessageBox.Show("订单取消成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MessageBox.Show("入库订单取消失败,系统错误。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); Logger.Error("入库订单取消失败,系统错误:", ex); } } } }
private void btnOperate_Click(object sender, EventArgs e) { try { string slipnumber = CConvert.ToString(dgvData.SelectedRows[0].Cells["SLIP_NUMBER"].Value); if (!string.IsNullOrEmpty(slipnumber)) { FrmPurchase frm = new FrmPurchase(); frm.SLIP = slipnumber; frm.ShowDialog(); frm.Dispose(); } } catch (Exception ex) { } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvData_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1) { DataGridViewRow dgvr = dgvData.Rows[e.RowIndex]; if (e.ColumnIndex == dgvData.Columns["DEPARTUAL_WAREHOUSE"].Index) { string warehouseCode = CConvert.ToString(dgvr.Cells["DEPARTUAL_WAREHOUSE"].Value); string productCode = CConvert.ToString(dgvr.Cells["PRODUCT_CODE"].Value); string orderSlipNumber = CConvert.ToString(txtSlipNumber.Text); BaseStockTable stockTable = bStock.GetModel(warehouseCode, productCode); decimal stock = 0; if (stockTable != null) { stock = CConvert.ToDecimal(stockTable.QUANTITY); } stock -= bAlloation.GetAlloationQuantity(orderSlipNumber, warehouseCode, productCode); dgvr.Cells["STOCK"].Value = stock; decimal quantity = CConvert.ToDecimal(dgvr.Cells["QUANTITY"].Value); decimal alloationQuantity = CConvert.ToDecimal(dgvr.Cells["ALLOATION_QUANTITY"].Value); if (alloationQuantity > stock) { dgvr.Cells["IS_ALLOATION"].Value = "NG"; dgvr.DefaultCellStyle.BackColor = COLOR_NG; } else { dgvr.Cells["IS_ALLOATION"].Value = "OK"; if (e.RowIndex % 2 == 0) { dgvr.DefaultCellStyle.BackColor = Color.White; } else { dgvr.DefaultCellStyle.BackColor = COLOR_DIFF_ROW; } } } } }
/// <summary> /// 获取滚动图片信息 /// </summary> /// <param name="sKey">授权信息</param> /// <param name="iLimit">每页条数</param> /// <param name="hasMore">总条数</param> /// <returns></returns> public DataSet GetQuesList(string sTestId, string sQuesType) { DataSet dst = null; StringBuilder sb = new StringBuilder(); m_dbo.RemoveAllParameters(); m_dbo.RemoveAllParameters(); sb = new StringBuilder(); sb.Append(" select "); sb.Append(" t1.* "); sb.Append(" from td_question t1 "); sb.Append(" WHERE 1 = 1 "); sb.Append(" and q_type=?qtype "); sb.Append(" and train_id=?train_id "); m_dbo.AddParameter("qtype", sQuesType); m_dbo.AddParameter("train_id", sTestId); sb.Append(" order by create_time "); try { dst = this.m_dbo.Select(CConvert.ToString(sb)); } catch (Exception e) { throw e; } finally { try { this.m_dbo.Close(); } catch { } } return(dst); }
/// <summary> /// 数据查询,绑定 /// </summary> private void BindData(int currentPage) { string strWhere = GetConduction(); DataSet ds = bPurchaseOrder.GetPurchaseSupplementList(strWhere, "", (currentPage - 1) * PageSize + 1, currentPage * PageSize); dgvData.Rows.Clear(); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow rows in ds.Tables[0].Rows) { int currentRowIndex = dgvData.Rows.Add(1); DataGridViewRow row = dgvData.Rows[currentRowIndex]; row.Cells[1].Selected = true; row.Cells["No"].Value = rows["Row"]; row.Cells["PRODUCT_CODE"].Value = rows["PRODUCT_CODE"]; row.Cells["PRODUCT_NAME"].Value = rows["PRODUCT_NAME"]; row.Cells["UNIT_NAME"].Value = rows["UNIT_NAME"]; row.Cells["QUANTITY"].Value = rows["QUANTITY"]; row.Cells["PRODUCT_GROUP_NAME"].Value = rows["PRODUCT_GROUP_NAME"]; row.Cells["MODEL_NUMBER"].Value = CConvert.ToString(rows["SPEC"]) + CConvert.ToString(rows["MODEL_NUMBER"]); row.Cells["SAFETY_STOCK"].Value = rows["SAFETY_STOCK"]; row.Cells["MAX_QUANTITY"].Value = rows["MAX_QUANTITY"]; row.Cells["MIN_PURCHASE_QUANTITY"].Value = rows["MIN_PURCHASE_QUANTITY"]; if ((CConvert.ToDecimal(rows["MAX_QUANTITY"]) - CConvert.ToDecimal(rows["QUANTITY"])) > CConvert.ToDecimal(rows["MIN_PURCHASE_QUANTITY"])) { row.Cells["NO_WORTH_QUANTITY"].Value = CConvert.ToDecimal(rows["MAX_QUANTITY"]) - CConvert.ToDecimal(rows["QUANTITY"]); } else { row.Cells["NO_WORTH_QUANTITY"].Value = rows["MIN_PURCHASE_QUANTITY"]; } row.Cells["PURCHASE_QUANTITY"].Value = bPurchaseOrder.GetPurchaseQuantity(txtWarehouseCode.Text.Trim(), rows["PRODUCT_CODE"].ToString()); } } else { MessageBox.Show("查询的数据不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } if (ds.Tables[0].Rows.Count < PageSize * currentPage) { dgvData.Rows.Add(PageSize - ds.Tables[0].Rows.Count); } }