public string GetVendorBank(string code)
{
try
{
ParametersrcDao paraDao = new ParametersrcDao(connStr);
List<Parametersrc> list = paraDao.Query(new Parametersrc { ParameterCode = code, ParameterType = "BankBranchName" });
if (list != null && list.Count > 0)
{
return list[0].remark;
}
else
{
return "";
}
}
catch (Exception ex)
{
throw new Exception("VendorMgr-->GetVendorBank" + ex.Message, ex);
}
}
/// <summary>
/// 根據cate_id獲取相應的sql語句字段
/// </summary>
/// add by wangwei0216w 2014/10/9
/// <returns>sql語句</returns>
public string GetStrbyCate_id(string cate_id)
{
IParametersrcImplDao _parametersrcDao = new ParametersrcDao(connStr);
string str = "";
List<Parametersrc> paras = _parametersrcDao.Query(new Parametersrc() { ParameterType = "product_cate" });
var subParas = paras.FindAll(p => p.TopValue == cate_id);
if (subParas.Count == 0)
{
str += cate_id + "','";
}
else
{
subParas.ForEach(p => str += p.ParameterCode + "','");
}
return str.Remove(str.Length - 3, 3);
}
public string ImportVendorBank(DataTable dt)
{
try
{
string result = "";
ArrayList _list = new ArrayList();
string user_email = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_email;
ParametersrcDao _paraDao = new ParametersrcDao(connStr);
string faCode = ""; int topValue = 0;
foreach (DataRow dr in dt.Rows)
{
Regex reg = new Regex("^[0-9]{7}$");
if (reg.IsMatch(dr[0].ToString()))
{
string sumCode = dr[0].ToString().Substring(0, 3);
var blist = _paraDao.Query(new Parametersrc { ParameterType = "BankBranchName", ParameterCode = dr[0].ToString() });
if (blist == null || blist.Count == 0)//不存在則保存總行數據
{
//查看總行是否已存在
if (faCode != sumCode)
{
var alist = _paraDao.Query(new Parametersrc { ParameterType = "BankName", ParameterCode = sumCode });
if (alist == null || alist.Count == 0)//不存在則保存總行數據
{
Parametersrc para = new Parametersrc();
para.ParameterType = "BankName";
para.ParameterCode = sumCode;
para.parameterName = dr[1].ToString().Split('-')[0].ToString();
para.remark = para.parameterName;
para.Kdate = DateTime.Now;
para.Kuser = user_email;
para.Used = 1;
_list.Add(_paraDao.Save(para));
}
faCode = sumCode;
}
}
else
{
result += dr[0].ToString() + "有重複匯入,";
break;
}
}
else
{
result += dr[0].ToString() + ',';
}
}
if (string.IsNullOrEmpty(result))//匯入數據無異常
{
//執行保存總行信息的事務
if (_mysqlDao.ExcuteSqlsThrowException(_list))
{
_list.Clear();
foreach (DataRow dr in dt.Rows)
{
string sumCode = dr[0].ToString().Substring(0, 3);
//查看總行是否已存在
if (faCode != sumCode)
{
topValue = _paraDao.Query(new Parametersrc { ParameterCode = sumCode, ParameterType = "BankName" }).FirstOrDefault().Rowid;
faCode = sumCode;
}
Parametersrc paraBranch = new Parametersrc();
paraBranch.ParameterType = "BankBranchName";
paraBranch.ParameterCode = dr[0].ToString();
paraBranch.parameterName = dr[1].ToString().Split('-')[1].ToString();
paraBranch.remark = dr[1].ToString();
paraBranch.Kdate = DateTime.Now;
paraBranch.Kuser = user_email;
paraBranch.Used = 1;
paraBranch.TopValue = topValue.ToString();
_list.Add(_paraDao.Save(paraBranch));
}
_mysqlDao.ExcuteSqlsThrowException(_list);
}
}
return result.TrimEnd(',');
}
catch (MySqlException ex)
{
throw new Exception(ex.Number.ToString() + ":VendorMgr-->ImportVendorBank-->" + ex.Message, ex);
}
catch (Exception ex)
{
throw new Exception("VendorMgr-->ImportVendorBank" + ex.Message, ex);
}
}