using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using DBUtility;
|
|
namespace SCM
|
{
|
public partial class Gy_UserSupplierRelationList : Form
|
{
|
private int HItemIDCol = 0;
|
private int HNumberCol = 0;
|
public DBUtility.frmBillQueryCondition_New frmCondition;
|
public const string ViewName = "h_v_Gy_UserSupplierRelationList";
|
public string ModName = "用户供应商权限表资料";
|
public string TreeTableName = "";
|
//权限
|
public const string ModRightName = "Gy_UserSupplierRelation";
|
public const string ModRightNameEdit = ModRightName + "_Edit";
|
public const string ModRightNameCheck = ModRightName + "_Check";
|
//
|
public DBUtility.ClsPub.Enum_InputMode InputMode; //录入状态标志(0-非录入状态 1-增加 2-修改)
|
public long HItemID;//项目ID
|
public long HItemGroupID;
|
WMSWeb.Service oWeb = new WMSWeb.Service();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
WMSWeb.ClsGy_UserSupplierRelation_Ctl oMatePrce = new WMSWeb.ClsGy_UserSupplierRelation_Ctl();
|
Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
|
WMSWeb.ClsGy_UserSupplierRelation_Model om = new WMSWeb.ClsGy_UserSupplierRelation_Model();
|
TreeNode CurNode = new TreeNode();
|
//拆分字符
|
char spChar =Convert.ToChar( "~");
|
public Gy_UserSupplierRelation oFrm;
|
public Gy_UserSupplierRelationList()
|
{
|
InitializeComponent();
|
}
|
|
|
//以下代码基本不需要修改
|
#region 固定代码
|
private void kh_Click(object sender, EventArgs e)
|
{
|
//kh.Checked = true;
|
//wl.Checked = false;
|
LoadTree();
|
Display();
|
}
|
|
private void wl_Click(object sender, EventArgs e)
|
{
|
//kh.Checked = false;
|
//wl.Checked = true;
|
LoadTree();
|
Display();
|
}
|
//窗体加载
|
private void Gy_UserSupplierRelation_Load(object sender, EventArgs e)
|
{
|
lblCaption.Text = ModName;
|
this.Text = ModName;
|
frmCondition = new DBUtility.frmBillQueryCondition_New(); //WEBS
|
LoadTree();
|
oSumGrid.ogrdMain = grdMain; //初始化 new
|
initGrid();
|
InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View;
|
}
|
//退出模块
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
//刷新
|
private void xs_Click(object sender, EventArgs e)
|
{
|
Display();
|
}
|
//查询
|
private void cx_Click(object sender, EventArgs e)
|
{
|
frmCondition = new DBUtility.frmBillQueryCondition_New(); //WEBS
|
frmCondition.Tag = "";
|
frmCondition.ViewName = ViewName;
|
frmCondition.ModName = this.Name;
|
frmCondition.ShowDialog();
|
if (frmCondition.Tag.ToString() == "OK")
|
{
|
Display();
|
}
|
}
|
//得到对应列
|
private Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
|
}
|
|
//删除项目
|
public void Delete()
|
{
|
//删除权限
|
if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName)) //WEBS
|
{
|
return;
|
}
|
//
|
if (AllowRow())
|
{
|
if (MessageBox.Show("确定要删除当前项目？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
|
{
|
//得到HITEMID
|
long sItemID;
|
sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[HItemIDCol].Value);
|
if (oWeb.set_DeleteUserSupplierRelation(sItemID, ref ClsPub.sExeReturnInfo))
|
{
|
MessageBox.Show(ClsPub.sExeReturnInfo);
|
return;
|
}
|
}
|
|
}
|
}
|
|
//树型 单击
|
private void tv_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
|
{
|
CurNode = e.Node;
|
if (CurNode != null)
|
{
|
if (CurNode.Nodes.Count == 0)
|
{
|
LoadAllNodes(CurNode);
|
}
|
frmCondition.SqlStr = "";
|
//找到选中结点
|
Display();
|
}
|
|
}
|
|
//删除
|
private void sc_Click(object sender, EventArgs e)
|
{
|
Delete();
|
}
|
//新增按钮
|
private void xz_Click(object sender, EventArgs e)
|
{
|
oFrm = new Gy_UserSupplierRelation();
|
oFrm.ShowDialog();
|
}
|
//修改
|
private void Sub_ShowBill()
|
{
|
Int64 lngBillKey = 0;
|
if (grdMain.CurrentRow == null)
|
return;
|
lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
|
if (lngBillKey == 0)
|
return;
|
WMSWeb.ClsGy_UserSupplierRelation_Ctl oBillMain = new WMSWeb.ClsGy_UserSupplierRelation_Ctl(); //WEBS
|
WMSWeb.ClsGy_UserSupplierRelation_Model oBill = new WMSWeb.ClsGy_UserSupplierRelation_Model();
|
if (oWeb.set_ShowUserSupplierRelation(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
oFrm = new Gy_UserSupplierRelation();
|
oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
|
//foreach (Model.ClsGy_UserSupplierRelation_Model oSub in oBillMain.DetailColl)
|
//{
|
// if (oSub.HChecker.Trim() != "")
|
// {
|
// oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
|
// }
|
//}
|
oBill.HItemID = lngBillKey;
|
oFrm.BillOld = oBill;
|
oFrm.BillNew = oBillMain;
|
oFrm.ShowDialog();
|
if (oFrm.BillChange)
|
{
|
if (MessageBox.Show("单据列表已经发生变化,是否刷新", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
|
{
|
timer1.Enabled = true;
|
}
|
}
|
}
|
else
|
{
|
MessageBox.Show("单据未找到", "提示");
|
}
|
oBill = null;
|
oBillMain = null;
|
}
|
//修改按钮
|
private void xg_Click(object sender, EventArgs e)
|
{
|
Sub_ShowBill();
|
}
|
//选中行是否正常
|
private bool AllowRow()
|
{
|
if (grdMain.CurrentRow.Index >= 0 && grdMain.CurrentRow.Index <= grdMain.RowCount - 1)
|
return true;
|
else
|
return false;
|
}
|
|
//保存列宽
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
//保存列宽
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
}
|
// 默认列宽
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
|
}
|
//时间控件
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
Display();
|
}
|
|
//初始化GRID
|
private void initGrid()
|
{
|
DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name);
|
}
|
|
|
#endregion
|
|
//显示列表
|
private void Display()
|
{
|
SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
|
DataSet DSet = new DataSet();
|
string sSql = "";
|
string sWhere = "";
|
string HParentID ="";
|
if (CurNode.Name.Trim().Length == 0 || CurNode.Text == ModName)
|
{
|
HParentID ="";
|
}
|
else
|
{
|
char c = Convert.ToChar(spChar);
|
string[] sr;
|
sr = CurNode.Text.Split(c);
|
HParentID = sr[0].ToString();
|
}
|
//过滤条件
|
DSet = oWeb.GetDisplayUserSupplierRelation(HParentID, sSql, ViewName, sWhere);
|
//生成首行标题
|
if (DSet == null)
|
{
|
MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
//释放冻结
|
DBUtility.Xt_BaseBillFun.CancelFrozenCol(grdMain);
|
//绑定
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
//设置合计列
|
string sTotalCol = "";
|
sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
|
string[] sT;
|
sT = sTotalCol.Split(Convert.ToChar(","));
|
oSumGrid.BuildTotalCols(sT);
|
//
|
//冻结
|
int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
|
string s = frmCondition.cmbHComplete.Text;
|
DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
|
//画线
|
//
|
Total();
|
}
|
|
//合计 new
|
private void Total()
|
{
|
if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
|
{
|
oSumGrid.SetGridsum();
|
oSumGrid.Total();
|
}
|
}
|
|
//加载子结点 //WEBS
|
private void LoadAllNodes(TreeNode sNode)
|
{
|
string sBill;
|
sBill = "h_v_Gy_UserRelation";
|
if (sNode != null)
|
{
|
try
|
{
|
sNode.Nodes.Clear();
|
DataSet Ds = oWeb.GetLoadAllNodes(sNode, sBill);
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["HItemID"].ToString(), Ds.Tables[0].Rows[i]["HNumber"].ToString() + spChar + Ds.Tables[0].Rows[i]["HName"].ToString(), 0, 1);
|
}
|
sNode.Expand();
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("加载子项目失败！" + e.Message, "提示");
|
}
|
}
|
}
|
//加载树形
|
private void LoadTree()
|
{
|
string sItemName;
|
sItemName = ModName;
|
try
|
{
|
tv.Nodes.Clear();
|
tv.ImageList = imageList1;
|
TreeNode sNode = tv.Nodes.Add("T0", sItemName, 0, 1);
|
LoadAllNodes(sNode);
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("加载树型失败！" + e.Message, "提示");
|
}
|
}
|
|
private void sh_Click(object sender, EventArgs e)
|
{
|
//审核权限
|
//if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, DBUtility.ClsPub.CurUserName))
|
//{
|
// return;
|
//}
|
//
|
//Int64 lngBillKey = 0;
|
//if (grdMain.SelectedRows.Count == 0)
|
//{
|
// MessageBox.Show("请至少选择一行！", "提示");
|
// return;
|
//}
|
//for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
|
//{
|
// lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value);
|
// if (lngBillKey == 0)
|
// return;
|
// DAL.ClsGy_UserSupplierRelation_Ctl oItem = new DAL.ClsGy_UserSupplierRelation_Ctl(); //WEBS
|
// //审核
|
// //查看是否已审核,关闭,作废
|
// if (oItem.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
|
// }
|
// else
|
// {
|
// MessageBox.Show("项目不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
// return;
|
// }
|
// //审核
|
// if (oItem.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
// {
|
// //MessageBox.Show("审核成功!第"+i.ToString()+"行", "提示");
|
// }
|
// else
|
// {
|
// MessageBox.Show("审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
// return;
|
// }
|
//}
|
//MessageBox.Show("审核成功，请刷新！", "提示");
|
//return;
|
}
|
|
private void fsh_Click(object sender, EventArgs e)
|
{
|
//审核权限
|
//if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, DBUtility.ClsPub.CurUserName))
|
//{
|
// return;
|
//}
|
//
|
//Int64 lngBillKey = 0;
|
//if (grdMain.SelectedRows.Count == 0)
|
//{
|
// MessageBox.Show("请至少选择一行！", "提示");
|
// return;
|
//}
|
//for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
|
//{
|
// lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value);
|
// if (lngBillKey == 0)
|
// return;
|
// DAL.ClsGy_UserSupplierRelation_Ctl oItem = new DAL.ClsGy_UserSupplierRelation_Ctl(); //WEBS
|
// //审核
|
// //查看是否已审核,关闭,作废
|
// if (oItem.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
|
// }
|
// else
|
// {
|
// MessageBox.Show("项目不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
// return;
|
// }
|
// //审核
|
// if (oItem.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
// {
|
// //MessageBox.Show("审核成功!第"+i.ToString()+"行", "提示");
|
// }
|
// else
|
// {
|
// MessageBox.Show("审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
// return;
|
// }
|
//}
|
//MessageBox.Show("审核成功，请刷新！", "提示");
|
//return;
|
}
|
|
private void pg_Click(object sender, EventArgs e)
|
{
|
////审核权限
|
////if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName))
|
////{
|
//// return;
|
////}
|
////
|
//double sPrice = 0;
|
//Int64 lngBillKey = 0;
|
//if (grdMain.SelectedRows.Count == 0)
|
//{
|
// MessageBox.Show("请至少选择一行！", "提示");
|
// return;
|
//}
|
////
|
////弹出窗体
|
////Gy_UserSupplierRelationDlg oDlg = new Gy_UserSupplierRelationDlg();
|
////oDlg.ShowDialog();
|
////if (oDlg.IsOk != 2)
|
////{
|
//// return;
|
////}
|
////sPrice = DBUtility.ClsPub.isDoule(oDlg.textBox1.Text);
|
////
|
//DAL.ClsGy_UserSupplierRelation_Ctl oItem = new DAL.ClsGy_UserSupplierRelation_Ctl();
|
//for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
|
//{
|
// lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HItemIDCol].Value);
|
// //
|
// if (lngBillKey == 0)
|
// continue;
|
// //查看是否已审核,关闭,作废
|
// //if (oItem.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
|
// //{
|
// // foreach (Model.ClsGy_UserSupplierRelation_Model oSub in oItem.DetailColl)
|
// // {
|
// // if (oSub.HChecker.Trim() != "")
|
// // {
|
// // MessageBox.Show("单据已审核!不能批量修改!", "提示");
|
// // return;
|
// // }
|
// // }
|
// //}
|
// //else
|
// //{
|
// // MessageBox.Show("项目不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
// // return;
|
// //}
|
// //审核
|
//}
|
//MessageBox.Show("操作完毕，请刷新", "提示");
|
//return;
|
}
|
|
//private void fz_Click(object sender, EventArgs e)
|
//{
|
// //审核权限
|
// //if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName))
|
// //{
|
// // return;
|
// //}
|
// //
|
// Gy_UserSupplierRelationCopy oFrm = new Gy_UserSupplierRelationCopy();
|
// oFrm.ShowDialog();
|
//}
|
|
private void yl_Click(object sender, EventArgs e)
|
{
|
DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
|
}
|
|
|
}
|
}
|
