private void Add_materialForm_Load(object sender, EventArgs e)
{
//限制值类型文本框的输入
(new InitFuncs()).Num_limited(this.panel1);
//初始化界面
InitFuncs inf = new InitFuncs();
//
inf.InitComboBox(s_Units, "[物料]计量单位");//初始化“列”单位Units
inf.InitComboBox(s_QualityDegree, "[物料]质量等级");//初始化“列”质量等级QualityDegree
inf.InitComboBox(this.s_ColorType,"[物料]色彩");
inf.InitComboBox(this.s_Format, "[物料]幅面");
inf.InitComboBox(this.s_Speed, "[物料]速度等级");
inf.InitComboBox(this.s_ProductType, "[物料]产品种类");
inf.InitComboBox(this.s_types, "[物料]机种");
inf.InitComboBox(this.s_ConfigType, "[物料]配置类型");
inf.InitComboBox(this.s_Brand, "[机型]品牌");
if (this.type == "edit")
{
s_MatID.ReadOnly = true;
string strsql = "select * from T_MatInf where MatID='{0}'";
strsql = string.Format(strsql, this.matId);
inf.ShowDatas(this.panel1, strsql);
}
else
{
s_MatID.ReadOnly = false;
s_InputTime.Text = DBUtil.getServerTime().ToString();
this.s_MatID.Text = this.matId;//单据模块用
}
}
private void BargainForm_Load(object sender, EventArgs e)
{
//限制值类型文本框的输入
(new InitFuncs()).Num_limited(this.panel1);
s_SaleUser.KeyDown+=new KeyEventHandler(InfoFind.UserName_KeyDown);
// 合同:无码数据初始化
InitFuncs inf = new InitFuncs();
//inf.InitComboBox(this.s_ResponseHour, "[合同]响应速度");
inf.InitComboBox(this.t_ContMaintetype, "[合同]签约类型");
//区域:有码数据初始化
inf.InitComboBox(this.t_UseType, "TB_machusedtype", "usedname"); //区域
inf.InitComboBox(this.t_ContMaintetype, "tb_maintetype", "maintetypename"); //保修类别
//合同:有码数据初始化
s_Jftype.SelectedIndex = 0;
s_ContractType.SelectedIndex = 0;
t_ContMaintetype.SelectedIndex = 0;
s_FeeType.SelectedIndex = 0;
s_PreChargeMethod.SelectedIndex = 0;
s_Payouttype.SelectedIndex = 0;
if (this.Type == "add")
{
this.s_Bargstatus.SelectedIndex = 1;
s_BargId.ReadOnly = false;
this.panel3.Enabled = false; //不允许设置相关物料
//this.panel4.Enabled = false;
}
else if (this.Type == "edit")
{
this.panel3.Enabled = true;
//this.panel4.Enabled = true;
string sel_sql = "select * from T_Bargains where sysid=" + this.BargSysId ;
inf.ShowDatas(this.panel1, sel_sql);
//以下两行必须在ShowDatas后
t_CustCode.Text = (new DBUtil()).Get_Single_val("T_CustomerInf", "custname", "custid", s_CustCode.Text.Trim());
this.custid_ = s_CustCode.Text.Trim();
this.t_UseType.Text = (new DBUtil()).Get_Single_val("TB_machusedtype", "usedname", "used_type", this.s_UseType.Text.Trim());
this.t_ContMaintetype.Text = (new DBUtil()).Get_Single_val("tb_maintetype", "maintetypename", "maintetypecode", this.s_ContMaintetype.Text.Trim());
this.t_CustCode.Text = (new DBUtil()).Get_Single_val("T_CustomerMac", "Mdepart", "sysid", this.n_MachineId.Text.Trim());
//显示计费用信息
show_fee_lst(this.BargSysId);
}
}
private void BargainBindAddhctype_Load(object sender, EventArgs e)
{
(new InitFuncs()).Num_limited(this.panel1);
//初始化无码数据
InitFuncs inf = new InitFuncs();
inf.InitComboBox(this.s_HcType, "[合同]幅面");
}
private void UserRoleForm_Load(object sender, EventArgs e)
{
//初始化DataGridView
InitDataGridView();
//初始化ComboBox
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitComboBox(this.comboBoxRole, "T_Roles", "RoleName");
string strUserName = (new DBUtil()).Get_Single_val("T_Users", "UserName", "UserId", this.userId);
this.txtUserName.Text = strUserName;
}
private void FinancialForm_Load(object sender, EventArgs e)
{
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitComboBox(this.comboBoxPayMethod, "T_PayMethod", "PMName");
this.txtCustId.KeyDown += new KeyEventHandler(InfoFind.CustId_KeyDown);
this.txtCustName.KeyDown += new KeyEventHandler(InfoFind.CustName_KeyDown);
if (this.financialType == "收入")
{
this.Text = "应收账务核销";
this.labelInfo.Text = "应收账务";
this.btnAutoVeri.Visible = false;
}
if (this.financialType == "支出")
{
this.Text = "应付账务核销";
this.labelInfo.Text = "应付账务";
this.btnAutoVeri.Visible = true;
}
this.curUserName = (this.MdiParent as MainForm).userName;
this.curWorkMonth = (this.MdiParent as MainForm).curWorkMonth;//获得主窗体的当前工作月
this.txtCustId.Focus();
}
/// <summary>
/// 单击treeview相应显示的TabControl并初始化ComboBox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SystreeView_AfterSelect(object sender, TreeViewEventArgs e)
{
string strNodeName = SystreeView.SelectedNode.Text.Trim();
InitFuncs initFuncs = new InitFuncs();
//用于记录每次输入的记录
ArrayList list = new ArrayList();
switch (strNodeName)
{
case "部门定义":
{
this.TabAdd.TabPages.Clear();
this.BranchAdd.Parent = this.TabAdd;
//this.TabAdd.SelectedIndex = 0;
InitDataGridView("T_Branch");
//初始化ComboBox
initFuncs.InitComboBox(this.comboxLeader, "T_Users", "UserName");
break;
}
case "操作角色定义":
{
this.TabAdd.TabPages.Clear();
this.Roles.Parent = this.TabAdd;
InitDataGridView("T_Roles");
break;
}
case "地区及区域积分":
{
this.TabAdd.TabPages.Clear();
this.AreaInf.Parent = this.TabAdd;
//this.TabAdd.SelectedIndex = 1;
InitDataGridView("T_AreaInf");
break;
}
case "操作员类别":
{
this.TabAdd.TabPages.Clear();
this.UserType.Parent = this.TabAdd;
//this.TabAdd.SelectedIndex = 2;
InitDataGridView("T_UserType");
break;
}
case "人员分管地区":
{
this.TabAdd.TabPages.Clear();
this.User_Area.Parent = this.TabAdd;
//this.TabAdd.SelectedIndex = 3;
InitDataGridView("T_User_Area");
//不让序列号显示出来
//dataGridView1.Columns["序列号"].Visible = false;
//初始化ComboBox
initFuncs.InitComboBox(this.comboBoxUserName, "T_Users", "UserName");
initFuncs.InitComboBox(this.comboBoxArea, "T_AreaInf", "Area");
break;
}
case "人员等级定义":
{
this.TabAdd.TabPages.Clear();
this.UserGrade.Parent = this.TabAdd;
//this.TabAdd.SelectedIndex = 4;
InitDataGridView("T_UserGrade");
//初始化ComboBox
initFuncs.InitComboBox(this.comboxUtype, "T_UserType", "UTypeName");
break;
}
case "仓库定义":
{
this.TabAdd.TabPages.Clear();
this.StoreHouse.Parent = this.TabAdd;
InitDataGridView("T_StoreHouse");
//初始化ComboBox
initFuncs.InitComboBox(this.comboBoxSHKeeper, "T_Users", "UserName");
initFuncs.InitComboBox(this.comboBoxSort, "T_Material_Sort", "SortName");
break;
}
case "发票定义":
{
this.TabAdd.TabPages.Clear();
this.Invoice.Parent = this.TabAdd;
//this.TabAdd.SelectedIndex = 5;
InitDataGridView("T_Invoice");
break;
}
case "物料卡片类别":
{
this.TabAdd.TabPages.Clear();
this.Material_Sort.Parent = this.TabAdd;
//this.TabAdd.SelectedIndex = 6;
InitDataGridView("T_Material_Sort");
break;
}
case "账款支付方式":
{
this.TabAdd.TabPages.Clear();
this.PayMethod.Parent = this.TabAdd;
InitDataGridView("T_PayMethod");
break;
}
case "客户重要度定义":
{
this.TabAdd.TabPages.Clear();
this.CustomerImp.Parent = this.TabAdd;
//this.TabAdd.SelectedIndex = 7;
InitDataGridView("T_CustomerImp");
break;
}
case "维修类别":
{
this.TabAdd.TabPages.Clear();
this.ServiceType.Parent = this.TabAdd;
InitDataGridView("T_ServiceType");
break;
}
case "工作类别定义":
{
this.TabAdd.TabPages.Clear();
this.WorkType.Parent = this.TabAdd;
InitDataGridView("T_WorkType");
break;
}
case "节假日定义":
{
this.TabAdd.TabPages.Clear();
this.Holidays.Parent = this.TabAdd;
InitDataGridView("T_Holidays");
break;
}
case "故障部位":
{
this.TabAdd.TabPages.Clear();
this.MachLocate.Parent = this.TabAdd;
InitDataGridView("T_MachLocate");
break;
}
case "故障部位部件":
{
this.TabAdd.TabPages.Clear();
initFuncs.InitComboBox(this.combPmachlctcode, "T_MachLocate", "machlctname");
this.machlocatepart.Parent = this.TabAdd;
InitDataGridView("T_machlocatepart");
break;
}
case "故障类别":
{
this.TabAdd.TabPages.Clear();
this.TrbType.Parent = this.TabAdd;
InitDataGridView("T_TrbType");
break;
}
case "故障类别明细":
{
this.TabAdd.TabPages.Clear();
initFuncs.InitComboBox(this.comboDtrbcode, "T_TrbType", "trbmemo");
this.TrbTypeDtl.Parent = this.TabAdd;
InitDataGridView("T_TrbTypeDtl");
break;
}
case "故障现象":
{
this.TabAdd.TabPages.Clear();
this.TelTrbType.Parent = this.TabAdd;
InitDataGridView("T_TelTrbType");
break;
}
case "故障现象明细":
{
this.TabAdd.TabPages.Clear();
initFuncs.InitComboBox(this.comboPtelcode, "T_TelTrbType", "telmemo");
this.machproblem.Parent = this.TabAdd;
InitDataGridView("T_machproblem");
break;
}
default:
break;
}
}
private void AddWorkForm_Load(object sender, EventArgs e)
{
//限制值类型文本框的输入
(new InitFuncs()).Num_limited(this.panel1);
this.lb_bargainType.Text = "";
this.lb_xysj.Text = "";
string sql_ = "";
//有码数据初始化
InitFuncs inf = new InitFuncs();
inf.InitComboBox(this.t_workResult, "TB_workResult", "repairstatusname"); //行动结果
inf.InitComboBox(this.t_ServiceType, "tb_maintetype", "maintetypename"); //服务类别
inf.InitComboBox(this.t_WorkType, "T_WorkType", "wcName"); //工作类别
inf.InitComboBox(this.t_WorkContent, "T_WorkType", "wcName"); //工作内容
// 无码数据初始化
inf.InitComboBox(this.s_wsStyle, "[派工]方式");
inf.InitComboBox(this.s_ActionResults, "[派工]行动结果");
inf.InitComboBox(this.s_UrgentDegree, "[召唤]紧急程度");
inf.InitComboBox(this.s_CallType, "[召唤]召唤类型");
inf.InitComboBox(this.s_wsStyle, "[召唤]方式");
inf.InitComboBox(this.s_ReportAttach, "[派工]报告附表");
inf.InitComboBox(this.s_ClearItem, "[派工]清洁项目");
inf.InitComboBox(this.s_ClearResult, "[派工]清洁结果");
inf.InitComboBox(this.s_Becauseof1, "[派工]取消原因");
inf.InitComboBox(this.s_Becauseof2, "[派工]原因备注");
//查询受理单编号
this.callid_ = (new DBUtil()).Get_Single_val("T_worksheet", "CallBillSysId", "sysid", this.sysid_);
//显示受理单的相关内容（有受理单的情况）
if (this.callid_.Trim() != "")
{
// 合同:无码数据初始化
this.panelWorkSheet.Visible = true;
this.lb_zhd.Visible = true;
this.n_CallBillSysId.Visible = true;
//显示召唤单
Show_CustCall(this.callid_);
t_CustCode.Text = (new DBUtil()).Get_Single_val("T_CustomerInf", "custname", "custid", s_CustCode.Text.Trim());
this.s_CustId.Text = this.s_CustCode.Text.Trim();
//
t_WorkType.Text = (new DBUtil()).Get_Single_val("T_worktype", "wcname", "wcid", s_WorkType.Text.Trim());
}
else
{
// 合同:无码数据初始化
this.panelWorkSheet.Visible = false;
this.lb_zhd.Visible = false;
this.n_CallBillSysId.Visible = false;
this.Height = 325;
}
return;
if (type == "add")
{
n_machineid.Text = this.machineid;
//获取客户编号
this.custid_ = (new DBUtil()).Get_Single_val("t_CustomerMac","custid","sysid",this.machineid);
this.s_mtype.Text = (new DBUtil()).Get_Single_val("t_CustomerMac", "mtype", "sysid", this.machineid);
s_CustCode.Text = this.custid_;
s_CustId.Text = this.custid_;
t_CustCode.Text = (new DBUtil()).Get_Single_val("T_CustomerInf", "custname", "custid", this.custid_);
s_wsCode.Focus();
}
else
{
sql_ = "select * from T_workSheet where sysid=" + this.sysid_;
inf.ShowDatas(this.panel1, sql_);
this.machineid = this.n_machineid.Text.Trim();
//查找或获取关联值
t_CustCode.Text = (new DBUtil()).Get_Single_val("T_CustomerInf", "custname", "custid", s_CustCode.Text.Trim());
this.t_workResult.Text = (new DBUtil()).Get_Single_val("TB_workResult", "repairstatusname", "repairstatuscode", this.s_workResult.Text.Trim());
this.t_WorkContent.Text = (new DBUtil()).Get_Single_val("T_WorkType", "wcName", "wcid", this.s_WorkContent.Text.Trim());
this.t_ServiceType.Text = (new DBUtil()).Get_Single_val("tb_maintetype", "maintetypename", "maintetypecode", this.s_ServiceType.Text.Trim());
//
if (s_AffectiveFlg.Text.ToLower().Trim() == "false")
{
radioButton1.Checked = true;
radioButton2.Checked = false;
}
else
{
radioButton1.Checked = false;
radioButton2.Checked = true;
}
}
}
private void FormCustContactAdd_Load(object sender, EventArgs e)
{
InitFuncs inf = new InitFuncs();
inf.InitComboBox(this.s_CType, "[客户]联系人类别");
s_custId.Text = this.custid;
if (this.type == "edit")
{
string strSql = "select * from T_CustContacts where CustID='{0}' and sysid={1}";
strSql = string.Format(strSql, this.custid, this.sysid_);
(new InitFuncs()).ShowDatas(this.panel1, strSql);
if (s_Sex.Text.Trim() == "男")
t_nan.Checked = true;
else
t_nu.Checked = true;
}
}
private void UserRelationForm_Load(object sender, EventArgs e)
{
string strUserName = (new DBUtil()).Get_Single_val("T_Users", "UserName", "UserId", this.userId);
this.txtCurUserName.Text = strUserName;
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitComboBox(this.comboBoxUserType, "T_UserType", "UtypeName");
initFuncs.InitComboBox(this.comboBoxUserGrade, "T_UserGrade", "Gname");
InitDataGridView();
}
private void EditBargFeeForm_Load(object sender, EventArgs e)
{
//有免印张数,无免印张数,有基本张数
if (this.Jftype == "有基本张数")
{
this.n_MyNum.Text = "";
this.n_MyNum.ReadOnly = true;
this.n_BaseNum.ReadOnly = false;
}
if (this.Jftype == "有免印张数")
{
this.n_BaseNum.Text = "";
this.n_MyNum.ReadOnly = false;
this.n_BaseNum.ReadOnly = true;
}
if (this.Jftype == "无免印张数")
{
this.n_BaseNum.Text = "";
this.n_MyNum.Text = "";
this.n_MyNum.ReadOnly = true;
this.n_BaseNum.ReadOnly = true;
}
//限制值类型文本框的输入
(new InitFuncs()).Num_limited(this.panel1);
InitFuncs inf = new InitFuncs();
inf.InitComboBox(this.s_HcType, "[合同]幅面");
this.t_BargId.Text = this.BargId;
s_HcType.SelectedIndex = 0;
if (this.Type == "add")
{
//s_BargId.Text = this.BargId;
n_barsysid.Text = this.BarSysId;
this.s_HcType.Enabled = true;
}
else
{
string sql_ = "select * from T_bargFee where barsysid=" + this.BarSysId
+" and hctype='"+this.hctype+"'";
(new InitFuncs()).ShowDatas(this.panel1, sql_);
this.s_HcType.Enabled = false;
}
//有免印张数,无免印张数,有基本张数
if (this.Jftype == "有基本张数")
{
this.n_MyNum.Text = "";
this.n_MyNum.ReadOnly = true;
this.n_BaseNum.ReadOnly = false;
}
if (this.Jftype == "有免印张数")
{
this.n_BaseNum.Text = "";
this.n_MyNum.ReadOnly = false;
this.n_BaseNum.ReadOnly = true;
}
if (this.Jftype == "无免印张数")
{
this.n_BaseNum.Text = "";
this.n_MyNum.Text = "";
this.n_MyNum.ReadOnly = true;
this.n_BaseNum.ReadOnly = true;
}
}
private void ReceiptModalConfigForm_Load(object sender, EventArgs e)
{
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitComboBox(this.comboBoxReceName, "T_ReceiptModal", "ReceName");
initFuncs.InitComboBox(this.comboBoxReceiptTypeID, "T_ReceiptModal", "ReceTypeID");
}
private void EditUserForm_Load(object sender, EventArgs e)
{
//初始化ComboBox
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitComboBox(this.comboBoxBranch, "T_Branch", "BName");
initFuncs.InitComboBox(this.comboBoxType, "T_UserType", "UTypeName");
// 合同:无码数据初始化
initFuncs.InitComboBox(this.s_groups, "[用户]所属组");
DBUtil dbUtil = new DBUtil();
if (this.type == "edit")
{
string strSql = "select * from T_Users where UserId='{0}'";
strSql = string.Format(strSql, this.userId);
initFuncs.ShowDatas(this.panelUser, strSql);
//处理ComboBox
this.comboBoxBranch.Text = dbUtil.Get_Single_val("T_Branch", "BName", "BId", this.s_BranchId.Text.Trim());
this.comboBoxType.Text = dbUtil.Get_Single_val("T_UserType", "UtypeName", "TypeId", this.s_DefaultUserType.Text.Trim());
//处理CheckBox
//string strYNAdmin = UsersDAO.GetYNAdmin(this.userId);
//if (strYNAdmin == "True")
// this.s_ynAdmin.Checked = true;
//else
// this.s_ynAdmin.Checked = false;
//处理确认密码
this.txtPasswordCheck.Text = (new DBUtil()).Get_Single_val("T_Users", "PassWord", "UserId", this.userId);
this.s_UserId.ReadOnly = true;
}
}
private void MacModelFormAdd_Load(object sender, EventArgs e)
{
//限制值类型文本框的输入
(new InitFuncs()).Num_limited(this.panelmodel);
InitFuncs inf = new InitFuncs();
//无码初始化
inf.InitComboBox(this.s_ProdCtgrID, "[机型]分类");
inf.InitComboBox(this.s_ModelType, "[机型]机型类别");
inf.InitComboBox(this.s_ModelGrade, "[机型]机器等级");
inf.InitComboBox(this.s_Modelbrand, "[机型]品牌");
if (this.type == "edit")
{
string strsql = "select * from T_Model where SysID='{0}'";
strsql = string.Format(strsql, this.ID);
(new InitFuncs()).ShowDatas(this.panelmodel, strsql);
}
}
private void SysEnviForm_Load(object sender, EventArgs e)
{
this.TabAdd.TabPages.Clear();//将Tab菜单隐藏起来
//this.WindowState = FormWindowState.Maximized;
try
{
InitFuncs initFuncs = new InitFuncs();
//初始化基础信息定义中的默认仓库选项
initFuncs.InitComboBox(this.comboBoxstore, "T_StoreHouse", "SHName");
tabParent_SelectedIndexChanged(sender, e);
}
catch (Exception et)
{
MessageBox.Show("初始化失败，原因:" + '\n' + et.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void CustomerCallAdd_Load(object sender, EventArgs e)
{
string sql_="";
string curtime_ = "";
s_Technician1.KeyDown+=new KeyEventHandler(InfoFind.UserName_KeyDown);
s_Technician2.KeyDown += new KeyEventHandler(InfoFind.UserName_KeyDown);
//区域:报修内容
(new InitFuncs()).InitComboBox(this.s_Teltrbtype, "T_TelTrbType", "telmemo");
//合同:有码数据初始化
(new InitFuncs()).InitComboBox(this.t_WorkType, "T_WorkType", "wcName"); //工作类别
// 合同:无码数据初始化
InitFuncs inf = new InitFuncs();
inf.InitComboBox(this.s_UrgentDegree, "[召唤]紧急程度");
inf.InitComboBox(this.s_ActionResults, "[召唤]行动结果");
DBUtil dbu = new DBUtil();
if (type == "add")
{
this.n_endflag.Text = "0"; //未派
s_operauser.Text = this.CurrentUser;
n_cmsysid.Text = this.cmsysid;
//根据Cmsysid得到<机型>、<机号>、<客户编号>
this.s_mtype.Text = dbu.Get_Single_val("T_CustomerMac", "mType", "sysid", this.cmsysid);
this.s_ManufactCode.Text = dbu.Get_Single_val("T_CustomerMac", "Manufactcode", "sysid", this.cmsysid);
this.s_CustCode.Text = dbu.Get_Single_val("T_CustomerMac", "custid", "sysid", this.cmsysid);
//获取预定技术员
this.s_Technician1.Text = dbu.Get_Single_val("T_CustomerMac", "ptech", "sysid", this.cmsysid);
//
curtime_ = DBUtil.getServerTime().ToString();
//查找或获取关联值
s_CallDate.Text = Convert.ToDateTime(curtime_).ToShortDateString();
s_CallTime.Text = Convert.ToDateTime(curtime_).ToShortTimeString();
}
else
{
sql_ = "select * from T_CustomerCall where sysid=" + this.CallId ;
inf.ShowDatas(this.panelCustCall, sql_);
this.cmsysid = this.n_cmsysid.Text.Trim();
//
t_WorkType.Text = (new DBUtil()).Get_Single_val("T_worktype", "wcname", "wcid", s_WorkType.Text.Trim());
this.s_CallDate.Text = Convert.ToDateTime(s_CallDate.Text).ToShortDateString();
this.s_CallTime.Text = Convert.ToDateTime(s_CallTime.Text).ToShortTimeString();
if (n_endflag.Text == "已派")
{
btn_time.Visible = true;
}
else
{
btn_time.Visible = false;
}
}
this.t_CustCode.Text = dbu.Get_Single_val("T_CustomerMac", "Mdepart", "sysid", this.cmsysid);
//根据Cmsysid得到<合同信息>//得到合同类别
sql_ = "select ContractType from T_Bargains where MachineId=" + this.cmsysid;
this.lb_bargainType.Text = "合同类别：" + dbu.Get_Single_val(sql_);
//显示联系人列表
show_contacts(this.cmsysid);
}
/// <summary>
/// 初始化绑定ComboBox
/// </summary>
private void InitComboBox()
{
//初始化ComboBox
InitFuncs initFuncs = new InitFuncs();
initFuncs.InitComboBox(this.comboBoxMainMenu, "T_MenuCfgMain", "MainMenu");
initFuncs.InitComboBox(this.comboBoxReceName, "T_ReceiptModal", "ReceName");
}
private void FormCopySettleInvoiceAdddet_Load(object sender, EventArgs e)
{
//限制值类型文本框的输入
(new InitFuncs()).Num_limited(this.panel1);
InitFuncs inf = new InitFuncs();
inf.InitComboBox(this.t_Itype, "T_Invoice", "ITName"); //发票类型
inf.InitComboBox(this.t_kpcorp, "T_StoreHouse", "SHName"); //所属公司
//开票内容，从物料表中取，要对应到具体的物料（以A打头的物料）
this.s_Icontent.Items.Clear();
string matid_ = "", matname_ = "";
string sql_ = "select matid,matname from T_matinf where Matid like 'A%'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql_);
for (int m = 0; m < dt.Rows.Count; m++)
{
matid_ = dt.Rows[m]["matid"].ToString().Trim();
matname_ = dt.Rows[m]["matname"].ToString().Trim();
this.s_Icontent.Items.Add("[" + matid_ + "]" + matname_);
}
//
this.s_SaleUser.KeyDown+=new KeyEventHandler(InfoFind.UserName_KeyDown);
this.s_Techuser.KeyDown += new KeyEventHandler(InfoFind.UserName_KeyDown);
//t_Itype.SelectedIndex = this.t_Itype.Items.IndexOf(Itype);
s_Ititle.Text = this.Ititle;
s_Icontent.Text = this.Icontent;
n_Inum.Text = this.Inum;
n_Iprice.Text = this.Iprice;
n_Imoney.Text = this.Imoney;
s_Techuser.Text = this.Itech;
s_SaleUser.Text = this.IsaleUser;
this.s_kpcorp.Text = (new DBUtil()).Get_Single_val("T_StoreHouse", "Shid", "shname", this.kpcorp);
this.s_Itype.Text = (new DBUtil()).Get_Single_val("T_Invoice", "ITcode", "Itname", this.Itype);
s_Memo.Text = this.Imemo;
s_groups.SelectedIndex = this.s_groups.Items.IndexOf(this.Igroup);
this.t_kpcorp.Text = (new DBUtil()).Get_Single_val("T_StoreHouse", "Shname", "shid", this.s_kpcorp.Text.Trim());
this.t_Itype.Text = (new DBUtil()).Get_Single_val("T_Invoice", "ITName", "Itcode", this.s_Itype.Text.Trim());
}
private void FormCustomerMaInvoiceAdd_Load(object sender, EventArgs e)
{
InitFuncs inf = new InitFuncs();
//inf.InitComboBox(this.t_IType, "[发票]发票种类");
inf.InitComboBox(this.t_IType, "T_Invoice", "ITName"); //发票类型
inf.InitComboBox(this.t_kpcorp, "T_StoreHouse", "SHName"); //所属公司
//开票内容，从物料表中取，要对应到具体的物料（以A打头的物料）
this.s_matid.Items.Clear();
string matid_="", matname_="";
string sql_ = "select matid,matname from T_matinf where Matid like 'A%'";
DataTable dt = (new SqlDBConnect()).Get_Dt(sql_);
for (int m = 0; m < dt.Rows.Count; m++)
{
matid_ = dt.Rows[m]["matid"].ToString().Trim();
matname_ = dt.Rows[m]["matname"].ToString().Trim();
this.s_matid.Items.Add("["+matid_+"]"+matname_);
}
//
s_CmSysId.Text = Cmsysid;
if (this.type == "edit")
{
string strSql = "select * from T_CustomerMaInvoice where CmSysId='{0}'and sysid='{1}'";
strSql = string.Format(strSql, this.Cmsysid,this.sysid);
(new InitFuncs()).ShowDatas(this.panelkp, strSql);
this.t_kpcorp.Text = (new DBUtil()).Get_Single_val("T_StoreHouse", "Shname", "shid", this.s_kpcorp.Text.Trim());
this.t_IType.Text = (new DBUtil()).Get_Single_val("T_Invoice", "ITName", "Itcode", this.s_IType.Text.Trim());
}
}
private void CustomerInfAdd_Load(object sender, EventArgs e)
{
//初始化ComboBox
InitFuncs inf = new InitFuncs();
inf.InitComboBox(this.s_CustType, "[客户]类别");
inf.InitComboBox(this.s_Degree, "[客户]等级");
inf.InitComboBox(this.s_whichTrade, "[客户]所在行业");
inf.InitComboBox(this.s_Country, "[客户]国家");
inf.InitComboBox(this.s_Province, "[客户]省");
inf.InitComboBox(this.s_City, "[客户]城市");
inf.InitComboBox(this.t_AreaCode, "T_AreaInf", "Area");
inf.InitComboBox(this.t_ImportanceDegreeId, "T_CustomerImp", "importance");
if (custid.Trim() == "")
{
tabControl1.Enabled = false;
}
else
{
tabControl1.Enabled = true ;
}
s_InputTime.Text = DBUtil.getServerTime().ToString();
if (this.type == "edit")
{
this.s_CustID.ReadOnly = true;
string strsql = "select * from T_CustomerInf where CustID='{0}'";
strsql = string.Format(strsql, this.custid);
inf.ShowDatas(this.panelcustomer, strsql);
//以下两行必须在ShowDatas后
DBUtil dbUtil = new DBUtil();
t_AreaCode.Text = (new DBUtil()).Get_Single_val("T_AreaInf", "Area", "areaId", S_AreaCode.Text.Trim());
t_ImportanceDegreeId.Text = (new DBUtil()).Get_Single_val("T_CustomerImp", "importance", "Iid", S_ImportanceDegreeId.Text.Trim());
//初始化抬头
SqlDBConnect SDB = new SqlDBConnect();
s_BillHead.Clear();
string strSql = "select BillHead as 发票抬头 from T_CustomerTitle where CustID='{0}'";//"select * from T_SelItems where ItemType='{0}'";
strSql = string.Format(strSql, s_CustID.Text.Trim());
DataSet ds = SDB.Get_Ds(strSql);
int Lins = ds.Tables[0].Rows.Count;
string[] match = new string[ds.Tables[0].Rows.Count];
for (int i = 0; i < match.Length; i++)
{
s_BillHead.Text += ds.Tables[0].Rows[i]["发票抬头"].ToString() + "\r\n";//回车换行
}
}
if (this.custid!="")
{//初始化联系人;
init_lxr();
//初始化发票
init_fp();
//初始化多地址
init_muladd();
}
//限制值类型文本框的输入
(new InitFuncs()).Num_limited(this.panelcustomer);
}
private void MatSplitMainForm_Load(object sender, EventArgs e)
{
InitFuncs initFuncs = new InitFuncs();
string strWhere = "select distinct MatName from T_Mat_Rela,T_MatInf where T_Mat_Rela.ParentMatID=T_MatInf.MatID";
initFuncs.InitComboBox(this.comboBoxMatName, "MatName", strWhere, 1);
this.txtCurUserName.Text = this.curUserName;//获取当前登陆用户名
initFuncs.InitComboBox(this.comboBoxMatType, "[物料]被拆物料类型");
this.s_OpaUser.Text = (new DBUtil()).Get_Single_val("T_Users", "UserId", "UserName", this.curUserName.Trim());
if (this.type == "edit")
{
//this.comboBoxOperateType.Text = Util.GetOperateTypeName(this.OperateType);
this.comboBoxMatName.Items.Clear();//编辑时，不允许修改被拆物料
this.s_ReceiptId.ReadOnly = true;
ShowDatas();
}
}
private void FormCustInvoiceAdd_Load(object sender, EventArgs e)
{
InitFuncs inf = new InitFuncs();
inf.InitComboBox(this.s_IType, "[发票]发票种类");
s_CustID.Text = this.custid;
if (this.type == "edit")
{
string strSql = "select * from T_CustomerInvoice where CustID='{0}' and sysid={1}";
strSql = string.Format(strSql, this.custid, this.sysid_);
(new InitFuncs()).ShowDatas(this.panel1, strSql);
}
}
