protected void fvMaterialNameAdd_ItemCreated(object sender, EventArgs e) { //修改状态 if (fvMaterialNameAdd.CurrentMode == FormViewMode.Edit) { //当前日期文本框获取焦点 var tb = (TextBox)fvMaterialNameAdd.FindControl("txtMaterialName"); if (tb != null) { //设置焦点 tb.Focus(); } } //新增状态 else if (fvMaterialNameAdd.CurrentMode == FormViewMode.Insert) { //当前文本框 TextBox tb; //获取最大物料代码 using (var da = new t_material_nameTableAdapter()) { //当前物料代码文本框获取焦点 tb = (TextBox)fvMaterialNameAdd.FindControl("txtMaterialCode"); if (tb != null) { //检查用户提供的物料代码参数标识 string materialCode = Request["code"]; if (materialCode == null || materialCode.Length <= 0) { //获取已经使用的最大的代码 materialCode = da.GetMaxCode().ToString(); } if (materialCode == null || materialCode.Length <= 0) { //设置默认物料代码 tb.Text = "A00001"; } else { //设置默认物料代码 tb.Text = string.Format( "{0}{1:00000}", materialCode.Substring(0, 1), (Math.Round(ydPublicMethod.Val(materialCode.Substring(1)), 0) + 1) ); } } } //当前lot卡号文本框获取焦点 tb = (TextBox)fvMaterialNameAdd.FindControl("txtMaterialName"); if (tb != null) { //设置焦点 tb.Focus(); } } }
/// <summary> /// 更新或者新增物料名称到物料名称清单表 /// </summary> /// <param name="daName">操作物料名称表的数据适配器</param> /// <param name="materialType">物料类别</param> /// <param name="supplierCode">供应商代码</param> /// <param name="supplierName">供应商名称</param> /// <param name="materialCode">物料代码/param> /// <param name="materialName">物料名称</param> /// <param name="materialSize">物料规格</param> /// <param name="materialUnit">物料单位</param> /// <param name="price">单价</param> /// <param name="addPerson">当前用户名称</param> private void UpdateToMaterialName( t_material_nameTableAdapter daName, string materialType, string supplierCode, string supplierName, ref string materialCode, string materialName, string materialSize, string materialUnit, decimal price, string addPerson ) { //获取当前指定的供应商名称/物料名称/物料规格/单位的物料名称行 var tab = daName.GetSupplierCodeAndMaterialCode( materialType, supplierName, materialName, materialSize, materialUnit ); //检测是否有查询到数据 if (tab.Rows.Count > 0) { //首行数据 var row = (DataSetMaterialName.t_material_nameRow)tab.Rows[0]; //设置取得物料代码 materialCode = row.material_code; //检查单价是否相同 if (price != row.price) { //执行更新单价 //保存到物料名称清单 if (daName.UpdateData( price, addPerson, materialType, supplierCode, supplierName, materialCode, materialName, materialSize, materialUnit ) <= 0) { throw new Exception("执行更新物料名称表中物料单价失败!"); } } //直接返回 return; } //没有查询到数据就执行新增 //获取最大的物料编码 var maxCode = string.Empty; if (materialCode.Trim().Length > 0) { maxCode = materialCode.Substring(0, 1); } if (maxCode.Length > 0) { maxCode = daName.GetMaxCodeLikeMaterialCode(maxCode + "%").ToString(); } if (maxCode.Length <= 0) { maxCode = daName.GetMaxCode().ToString(); } //最大编码如果没有找到 if (maxCode.Length <= 0) { //设置默认物料代码 materialCode = "A00001"; } else { //设置默认物料代码 materialCode = string.Format( "{0}{1:00000}", maxCode.Substring(0, 1), (Math.Round(ydPublicMethod.Val(maxCode.Substring(1)), 0) + 1) ); } //执行添加 if (daName.InsertData( materialType, supplierCode, supplierName, materialCode, materialName, materialSize, materialUnit, price, addPerson ) <= 0) { throw new Exception("新增保存到物料名称清单失败!"); } }
/// <summary> /// 根据输入的参数值来执行更新数据 /// </summary> /// <param name="e">传入的带有数据的事件参数</param> /// <returns></returns> private bool UpdateData(FormViewUpdateEventArgs e) { //数据适配器 //当前添加语句对象 //当前数据库连接 using (var da = new v_material_inTableAdapter()) using (var conn = da.Connection) { //打开数据库连接 conn.Open(); //开启事务 using (var tran = conn.BeginTransaction()) { //设置事务 da.Transaction = tran; //试运行 try { //当前行单号 string billNum = Convert.ToString(e.Keys[0]); //获取数据 using (var tab = da.GetDataByBillNum(billNum)) { //检查是否获取到行 if (tab.Rows.Count == 0) { //显示失败 throw new Exception("当前记录已经被其他用户删除!"); } //数据适配器 using (var daHead = new t_material_in_headTableAdapter()) using (var daContent = new t_material_in_contentTableAdapter()) using (var daBalance = new t_material_balanceTableAdapter()) using (var daName = new t_material_nameTableAdapter()) using (var daPrice = new t_material_price_historyTableAdapter()) { //设置数据库连接 daHead.Connection = daContent.Connection = daBalance.Connection = daName.Connection = daPrice.Connection = conn; //设置事务 daHead.Transaction = daContent.Transaction = daBalance.Transaction = daName.Transaction = daPrice.Transaction = tran; //将之前的单据内容写回 foreach (DataSetMaterialIn.v_material_inRow row in tab.Rows) { //从原料结存清单中扣除 if (!ydOperateMaterial.DecreaseMaterialBalance( daBalance, BillType.In, row.material_type, row.supplier_name, row.material_name, row.price, row.qty )) { return false; } } //从单据内容中删除 if (daContent.DeleteByBillNum(billNum) <= 0) { throw new Exception("从单据内容中删除失败!"); } //从单据表头中删除 if (daHead.Delete(billNum) <= 0) { throw new Exception("从单据表头中删除失败!"); } //日期 DateTime billDate = Convert.ToDateTime(e.NewValues["bill_date"]); //供应商代码 string supplierCode = Convert.ToString(e.NewValues["supplier_code"]); //供应商名称 string supplierName = Convert.ToString(e.NewValues["supplier_name"]); //送货单号 string deliveryNum = Convert.ToString(e.NewValues["delivery_num"]); //单据备注 string billRemark = Convert.ToString(e.NewValues["remark"]); //录入员 string addPerson = e.NewValues["add_person"].ToString(); //录入时间 DateTime addTime = Convert.ToDateTime(e.NewValues["add_time"]); //最后修改时间 DateTime lastChangeTime = Convert.ToDateTime(e.NewValues["last_change_time"]); //含有数据的行数 int iCountContent = 0; //遍历子表执行保存 for (int iRow = 0; iRow < 10; iRow++) { //列号 var iCol = -1; //子表各控件 var tr = tabDataListSon.Rows[iRow + 1]; var litRowId = (Literal)tr.Cells[++iCol].Controls[0]; var txtMaterialType = (TextBox)tr.Cells[++iCol].Controls[0]; var txtMaterialCode = (TextBox)tr.Cells[++iCol].Controls[0]; var txtMaterialName = (TextBox)tr.Cells[++iCol].Controls[0]; var txtMaterialSize = (TextBox)tr.Cells[++iCol].Controls[0]; var txtQty = (TextBox)tr.Cells[++iCol].Controls[0]; var txtMaterialUnit = (TextBox)tr.Cells[++iCol].Controls[0]; var txtPrice = (TextBox)tr.Cells[++iCol].Controls[0]; var txtRemark = (TextBox)tr.Cells[++iCol].Controls[0]; //取得数据 byte rowId = Convert.ToByte(litRowId.Text); string materialType = txtMaterialType.Text; string materialCode = txtMaterialCode.Text; string materialName = txtMaterialName.Text; string materialSize = txtMaterialSize.Text; decimal qty = txtQty.Text.Trim().Length <= 0 ? 0m : decimal.Parse(txtQty.Text.Trim()); string materialUnit = txtMaterialUnit.Text; decimal price = txtPrice.Text.Trim().Length <= 0 ? 0m : decimal.Parse(txtPrice.Text.Trim()); string remark = txtRemark.Text; //存在数据才保存 if (materialCode.Length > 0 && materialName.Length > 0 && materialUnit.Length > 0 && qty > 0) { //保存到原料结存清单 if (daBalance.InsertData( materialType, supplierCode, supplierName, materialCode, materialName, materialSize, qty, materialUnit, price, remark, addPerson, false ) <= 0) { throw new Exception("保存到原料结存清单失败!"); } //保存到单据内容清单 if (daContent.Insert( billNum, rowId, materialType, materialCode, materialName, materialSize, qty, materialUnit, price, remark ) <= 0) { throw new Exception("保存到单据内容清单失败!"); } //保存到物料名称清单 if (daName.UpdateData( price, addPerson, materialType, supplierCode, supplierName, materialCode, materialName, materialSize, materialUnit ) <= 0) { //获取最大的物料编码 var maxCode = string.Empty; if (materialCode.Trim().Length > 0) { maxCode = materialCode.Substring(0, 1); } if (maxCode.Length > 0) { maxCode = daName.GetMaxCodeLikeMaterialCode(maxCode + "%").ToString(); } if (maxCode.Length <= 0) { maxCode = daName.GetMaxCode().ToString(); } //最大编码如果没有找到 if (maxCode.Length <= 0) { //设置默认物料代码 materialCode = "A00001"; } else { //设置默认物料代码 materialCode = string.Format( "{0}{1:00000}", maxCode.Substring(0, 1), (Math.Round(ydPublicMethod.Val(maxCode.Substring(1)), 0) + 1) ); } //执行添加 if (daName.InsertData( materialType, supplierCode, supplierName, materialCode, materialName, materialSize, materialUnit, price, addPerson ) <= 0) { throw new Exception("保存到物料名称清单失败!"); } } //保存到历史单价清单 if (daPrice.UpdateData( price, addPerson, materialType, supplierCode, supplierName, materialCode, materialName, materialSize, materialUnit ) <= 0) { //执行添加 if (daPrice.InsertData( materialType, supplierCode, supplierName, materialCode, materialName, materialSize, materialUnit, price, addPerson ) <= 0) { throw new Exception("保存到物料历史单价清单失败!"); } } //含有数据的行数计数 iCountContent++; } } //保存表头 if (iCountContent > 0) { if (daHead.Insert( billDate, billNum, supplierCode, supplierName, deliveryNum, billRemark, addPerson, addTime, lastChangeTime ) <= 0) { throw new Exception("从单据表头中删除失败!"); } } } } //提交事务 tran.Commit(); //返回成功 return true; } catch (Exception ex) { //回滚事务 tran.Rollback(); //非数字返回失败 throw new Exception(ex.Message); } } } }