| | |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | string sql = string.Format(@"select s.HItemID,s.HNumber 编码,s.HName 名称,s.HHelpCode 助记码,s.HShortName 简称,s.HAddress 地址,s.HLinkMan 联系人,s.HLinkPhone 联系电话 |
|---|
| | | string sql = string.Format(@"select s.HItemID,s.HUSEORGID,o.Hname 使用组织,s.HCREATEORGID ,d.Hname 创建组织,s.HNumber 编码,s.HName 名称,s.HHelpCode 助记码,s.HShortName 简称,s.HAddress 地址,s.HLinkMan 联系人,s.HLinkPhone 联系电话 |
|---|
| | | ,s.HMobilePhone 手机,s.HFax 传真,s.HPostalCode 邮编,s.HEmail 电子邮件,s.HCorMan 法人代表,s.HBank 开户银行,s.HBankAccount 银行账号, |
|---|
| | | s.HTaxNum 税务登记号,s.HEnglishName 英文名称,s.HEngLishAddress 英文地址,s.HCountry 国家,s.HStopflag 禁用标志 |
|---|
| | | ,s.HRemark 备注,s.HAreaID 地区ID,a.HName 地区名称,s.HTaxRate 增值税率,s.HCurID 默认货币ID,r.HName 默认货币, |
|---|
| | |
|---|
| | | left join Gy_AreaSet a on s.HAreaID=a.HItemID |
|---|
| | | left join Gy_Currency r on s.HCurID=r.HItemID |
|---|
| | | left join Gy_SettleStyle e on s.HSSID=e.HItemID |
|---|
| | | left join Xt_ORGANIZATIONS o on s.HUSEORGID=o.HItemID |
|---|
| | | left join Xt_ORGANIZATIONS d on s.HCREATEORGID=d.HItemID |
|---|
| | | where s.HItemID='" + HInterID + "'"); |
|---|
| | | ds = oCN.RunProcReturn(sql, "Gy_Supplier"); |
|---|
| | | |
|---|
| | |
|---|
| | | ",HShortName,HAddress,HLinkMan,HLinkPhone,HMobilePhone" + |
|---|
| | | ",HFax,HPostalCode,HEmail,HBank,HBankAccount" + |
|---|
| | | ",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" + |
|---|
| | | ",HEnglishAddress,HCurID,HSSID,HAreaID,HMaterClass) " + |
|---|
| | | ",HEnglishAddress,HCurID,HSSID,HAreaID,HMaterClass,HUSEORGID,HCREATEORGID) " + |
|---|
| | | " values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HParentID + "'" + |
|---|
| | | "," + HLevel + ",1,'" + HStopflag + "','" + HRemark + "'" + |
|---|
| | | ",'" + HShortName + "','" + HAddress + "','" + HLinkMan + "','" + HLinkPhone + "','" + HMobilePhone + "'" + |
|---|
| | | ",'" + HFax + "','" + HPostalCode + "','" + HEmail + "','" + HBank + "','" + HBankAccount + "'" + |
|---|
| | | ",'" + HTaxNum + "','" + HTaxRate + "','" + HCountry + "','" + HCorMan + "','" + HEnglishName + "'" + |
|---|
| | | ",'" + HEnglishAddress + "'," + HCurID + "," + HSSID + "," + HAreaID +" ,'" + HMaterClass + |
|---|
| | | ",'" + HEnglishAddress + "'," + HCurID + "," + HSSID + "," + HAreaID +" ,'" + HMaterClass + " ','" + HUseOrgID + "' ,'" + HCreateOrgID + |
|---|
| | | "') "); |
|---|
| | | //修改上级为非末级代码 |
|---|
| | | oCN.RunProc("Update Gy_Supplier set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | |
|---|
| | | ",HCurID=" + HCurID.ToString() + |
|---|
| | | ",HSSID=" + HSSID.ToString() + |
|---|
| | | ",HMaterClass='" + HMaterClass + |
|---|
| | | "',HUSEORGID='" + HUseOrgID.ToString() + |
|---|
| | | "',HCREATEORGID='" + HCreateOrgID.ToString() + |
|---|
| | | "',HAreaID=" + HAreaID.ToString() + "Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | |
|---|
| | | |
|---|
