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);
}
}
