void add_pqna(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerrecordNAEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into R_PQNA(");
strSql.Append("NA001,NA002,NA003,NA004,NA005,NA006,NA007,NA008,NA009)");
strSql.Append(" values (");
strSql.Append("@NA001,@NA002,@NA003,@NA004,@NA005,@NA006,@NA007,@NA008,@NA009)");
SqlParameter [] parameters =
{
new SqlParameter("@NA001", SqlDbType.NVarChar, 20),
new SqlParameter("@NA002", SqlDbType.NVarChar, 20),
new SqlParameter("@NA003", SqlDbType.NVarChar, 20),
new SqlParameter("@NA004", SqlDbType.NVarChar, 20),
new SqlParameter("@NA005", SqlDbType.NVarChar, 20),
new SqlParameter("@NA006", SqlDbType.NVarChar, 20),
new SqlParameter("@NA007", SqlDbType.NVarChar, 20),
new SqlParameter("@NA008", SqlDbType.NVarChar, 50),
new SqlParameter("@NA009", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.NA001;
parameters [1].Value = model.NA002;
parameters [2].Value = model.NA003;
parameters [3].Value = model.NA004;
parameters [4].Value = model.NA005;
parameters [5].Value = model.NA006;
parameters [6].Value = model.NA007;
parameters [7].Value = model.NA008;
parameters [8].Value = model.NA009;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// save data to r_pqn,r_pqna
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <param name="strList"></param>
/// <param name="logins"></param>
/// <returns></returns>
public bool Save(MulaolaoLibrary.CustomerrecordEntity model, DataTable table, string logins)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
model.KH01 = getOddNum( );
add_pqn(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_369", "客户信息传递记录表(R_369)", logins, Drity.GetDt( ), model.KH01, strSql.ToString( ).Replace("'", "''"), "新增", "增加"), null);
MulaolaoLibrary.CustomerrecordNAEntity _na = new MulaolaoLibrary.CustomerrecordNAEntity( );
_na.NA001 = model.KH01;
for (int i = 0; i < table.Rows.Count; i++)
{
_na.NA002 = table.Rows [i] ["NA002"].ToString( );
_na.NA003 = table.Rows [i] ["NA003"].ToString( );
_na.NA004 = table.Rows [i] ["NA004"].ToString( );
_na.NA005 = table.Rows [i] ["NA005"].ToString( );
_na.NA006 = table.Rows [i] ["NA006"].ToString( );
_na.NA007 = table.Rows [i] ["NA007"].ToString( );
_na.NA008 = table.Rows [i] ["NA008"].ToString( );
_na.NA009 = table.Rows [i] ["NA009"].ToString( );
add_pqna(SQLString, strSql, _na);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void delete_pqna(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerrecordNAEntity model)
{
strSql = new StringBuilder( );
strSql.Append("DELETE FROM R_PQNA ");
strSql.AppendFormat("WHERE idx={0}", model.idx);
SQLString.Add(strSql, null);
}
public R_FrmCustomerrecord( )
{
InitializeComponent();
_kh = new MulaolaoLibrary.CustomerrecordEntity( );
_na = new MulaolaoLibrary.CustomerrecordNAEntity( );
_bll = new MulaolaoBll.Bll.CustomerrecordBll( );
tableView = new DataTable( );
lab.Visible = false;
GridViewMoHuSelect.SetFilter(gridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { this.gridView1 });
UserInfoMation.tableName = this.Name;
}
/// <summary>
/// edit data to r_pqn,r_pqna
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <param name="logins"></param>
/// <param name="strList"></param>
/// <returns></returns>
public bool Edit(MulaolaoLibrary.CustomerrecordEntity model, DataTable table, string logins, List <string> strList)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
edit_pqn(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_369", "客户信息传递记录表(R_369)", logins, Drity.GetDt( ), model.KH01, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑"), null);
MulaolaoLibrary.CustomerrecordNAEntity _na = new MulaolaoLibrary.CustomerrecordNAEntity( );
_na.NA001 = model.KH01;
for (int i = 0; i < table.Rows.Count; i++)
{
_na.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
_na.NA002 = table.Rows [i] ["NA002"].ToString( );
_na.NA003 = table.Rows [i] ["NA003"].ToString( );
_na.NA004 = table.Rows [i] ["NA004"].ToString( );
_na.NA005 = table.Rows [i] ["NA005"].ToString( );
_na.NA006 = table.Rows [i] ["NA006"].ToString( );
_na.NA007 = table.Rows [i] ["NA007"].ToString( );
_na.NA008 = table.Rows [i] ["NA008"].ToString( );
_na.NA009 = table.Rows [i] ["NA009"].ToString( );
if (_na.idx < 1)
{
add_pqna(SQLString, strSql, _na);
}
else
{
edit_pqna(SQLString, strSql, _na);
}
}
if (strList.Count > 0)
{
foreach (string s in strList)
{
_na.idx = Convert.ToInt32(s);
delete_pqna(SQLString, strSql, _na);
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void edit_pqna(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerrecordNAEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update R_PQNA set ");
strSql.Append("NA001=@NA001,");
strSql.Append("NA002=@NA002,");
strSql.Append("NA003=@NA003,");
strSql.Append("NA004=@NA004,");
strSql.Append("NA005=@NA005,");
strSql.Append("NA006=@NA006,");
strSql.Append("NA007=@NA007,");
strSql.Append("NA008=@NA008,");
strSql.Append("NA009=@NA009 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@NA001", SqlDbType.NVarChar, 20),
new SqlParameter("@NA002", SqlDbType.NVarChar, 20),
new SqlParameter("@NA003", SqlDbType.NVarChar, 20),
new SqlParameter("@NA004", SqlDbType.NVarChar, 20),
new SqlParameter("@NA005", SqlDbType.NVarChar, 20),
new SqlParameter("@NA006", SqlDbType.NVarChar, 20),
new SqlParameter("@NA007", SqlDbType.NVarChar, 20),
new SqlParameter("@NA008", SqlDbType.NVarChar, 50),
new SqlParameter("@NA009", SqlDbType.NVarChar, 20),
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.NA001;
parameters [1].Value = model.NA002;
parameters [2].Value = model.NA003;
parameters [3].Value = model.NA004;
parameters [4].Value = model.NA005;
parameters [5].Value = model.NA006;
parameters [6].Value = model.NA007;
parameters [7].Value = model.NA008;
parameters [8].Value = model.NA009;
parameters [9].Value = model.idx;
SQLString.Add(strSql, parameters);
}
