/// <summary>
/// 新增客户资料数据(包含文件上传)
/// </summary>
/// <param name="_UA01">实体类</param>
/// <returns>影响行数</returns>
public int AddCustomerBase(CustomerBase _CustomerBase, Appendix _Appendix)
{
try
{
CreateSqlHandler <Appendix> _CreateSqlHandlerAppendix = new CreateSqlHandler <Appendix>();
CreateSqlHandler <CustomerBase> _CreateSqlHandlerCustomerBase = new CreateSqlHandler <CustomerBase>();
//生成CA01Sql语句
string strCA01Sql = _CreateSqlHandlerCustomerBase.Insert(_CustomerBase, "CA01");
//生成GA07Sql语句
string strGA07Sql = _CreateSqlHandlerAppendix.Insert(_Appendix, "GA07");
int num = Math.Abs(Provider.ExecuteNonQuery("PRO_CA01", 1, new SqlParameter[] {
new SqlParameter()
{
ParameterName = @"sqlCA01", Value = strCA01Sql, DbType = DbType.String
},
new SqlParameter()
{
ParameterName = @"sqlGA07", Value = strGA07Sql, DbType = DbType.String
},
new SqlParameter()
{
ParameterName = @"CA01999", Value = _CustomerBase.CA01999, DbType = DbType.String
}
}));
return(num);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 修改客户资料数据
/// </summary>
/// <param name="_UA01">实体类</param>
/// <returns>影响行数</returns>
public int UpdateCustomerBase(CustomerBase _CustomerBase)
{
try
{
CreateSqlHandler <CustomerBase> _CreateSqlHandler = new CreateSqlHandler <CustomerBase>();
//生成Sql语句
string strSql = _CreateSqlHandler.Update(_CustomerBase, "CA01", string.Format(" WHERE CA01001 = '{0}' ", _CustomerBase.CA01001));
int num = Math.Abs(Provider.ExecuteNonQuery(strSql, 0, null));
return(num);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 新增客户资料数据
/// </summary>
/// <param name="_UA01">实体类</param>
/// <returns>影响行数</returns>
public int AddCustomerBase(CustomerBase _CustomerBase)
{
try
{
CreateSqlHandler <CustomerBase> _CreateSqlHandler = new CreateSqlHandler <CustomerBase>();
//生成Sql语句
string strSql = _CreateSqlHandler.Insert(_CustomerBase, "CA01");
int num = Math.Abs(Provider.ExecuteNonQuery(strSql, 0, null));
return(num);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 新增客户资料数据(包含文件上传)
/// </summary>
/// <param name="_UA01">实体类</param>
/// <returns>影响行数</returns>
public int AddCustomerBase(CustomerBase _CustomerBase, List <Appendix> _Appendix)
{
string strGA07Sql = string.Empty;
int num = 0;
try
{
CreateSqlHandler <Appendix> _CreateSqlHandlerAppendix = new CreateSqlHandler <Appendix>();
CreateSqlHandler <CustomerBase> _CreateSqlHandlerCustomerBase = new CreateSqlHandler <CustomerBase>();
//生成CA01Sql语句
string strCA01Sql = _CreateSqlHandlerCustomerBase.Insert(_CustomerBase, "CA01");
if (_Appendix.Count > 0)
{
//生成GA07Sql语句
for (int i = 0; i < _Appendix.Count; i++)
{
strGA07Sql += _CreateSqlHandlerAppendix.Insert(_Appendix[i], "GA07");
}
num = Math.Abs(Provider.ExecuteNonQuery("PRO_CA01", 1, new SqlParameter[] {
new SqlParameter()
{
ParameterName = @"sqlCA01", Value = strCA01Sql, DbType = DbType.String
},
new SqlParameter()
{
ParameterName = @"sqlGA07", Value = strGA07Sql, DbType = DbType.String
},
new SqlParameter()
{
ParameterName = @"CA01999", Value = _CustomerBase.CA01999, DbType = DbType.String
}
}));
}
else
{
num = Math.Abs(Provider.ExecuteNonQuery(strCA01Sql, 0, null));
}
return(num);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 新增客户文件资料数据(多条)
/// </summary>
/// <param name="_UA01">实体类</param>
/// <returns>影响行数</returns>
public int AddCustomerFileBase(List <Appendix> listAppendix)
{
try
{
CreateSqlHandler <Appendix> _CreateSqlHandler = new CreateSqlHandler <Appendix>();
StringBuilder sb = new StringBuilder();
//生成Sql语句
foreach (Appendix _CustomerFile in listAppendix)
{
string strSql = _CreateSqlHandler.Insert(_CustomerFile, "GA07");
sb.AppendLine(strSql);
}
int num = Math.Abs(Provider.ExecuteNonQuery(sb.ToString(), 0, null));
return(num);
}
catch (Exception ex)
{
throw ex;
}
}
