void AddMain(SqlCommand cmd, HengDaEntity.FormMainHeader _modelHeader, StringBuilder strSql, SqlTransaction tran, SqlConnection conn)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO HDSHD (");
strSql.Append("SHD001,SHD002,SHD003,SHD004,SHD005,SHD006,SHD007,SHD008)");
strSql.Append(" VALUES (");
strSql.Append("@SHD001,@SHD002,@SHD003,@SHD004,@SHD005,@SHD006,@SHD007,@SHD008)");
SqlParameter[] parameter =
{
new SqlParameter("@SHD001", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD002", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD003", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD004", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD005", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD006", SqlDbType.DateTime),
new SqlParameter("@SHD007", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD008", SqlDbType.NVarChar, 20)
};
parameter[0].Value = _modelHeader.SHD001;
parameter[1].Value = _modelHeader.SHD002;
parameter[2].Value = _modelHeader.SHD003;
parameter[3].Value = _modelHeader.SHD004;
parameter[4].Value = _modelHeader.SHD005;
parameter[5].Value = _modelHeader.SHD006;
parameter[6].Value = _modelHeader.SHD007;
parameter[7].Value = _modelHeader.SHD008;
cmd.Parameters.Clear( );
SqlHelper.PrepareCommand(cmd, conn, tran, strSql.ToString( ), parameter);
cmd.CommandText = strSql.ToString( );
cmd.ExecuteNonQuery( );
}
void autoQuery( )
{
Ergodic.SpliClear(spList);
Ergodic.SpliEnableFalse(spList);
Ergodic.TablePageEnableClear(pageList);
Ergodic.TablePageEnableFalse(pageList);
gridView1.OptionsBehavior.Editable = false;
gridView2.OptionsBehavior.Editable = false;
_modelHeader = _bll.GetDataTable(_modelHeader.SHD001);
if (_modelHeader == null)
{
return;
}
textBox1.Text = _modelHeader.SHD001;
comboBox1.Text = _modelHeader.SHD003;
comboBox2.Text = _modelHeader.SHD004;
comboBox3.Text = _modelHeader.SHD005;
if (_modelHeader.SHD006 > DateTime.MinValue && _modelHeader.SHD006 < DateTime.MaxValue)
{
dateTimePicker1.Value = _modelHeader.SHD006;
}
textBox5.Text = _modelHeader.SHD007;
textBox6.Text = _modelHeader.SHD008;
if (_modelHeader.SHD002 != null)
{
queryL = _bll.GetDataTableL(_modelHeader.SHD002);
if (queryL != null && queryL.Rows.Count > 0)
{
lookUpEdit1.Text = queryL.Rows[0]["DFA002"].ToString( );
}
}
refre( );
}
protected override void select( )
{
base.select( );
_modelHeader = new HengDaEntity.FormMainHeader( );
HengDaOther.FormMainQuery query = new HengDaOther.FormMainQuery( );
query.StartPosition = FormStartPosition.CenterScreen;
query.PassDataBetweenForm += new HengDaOther.FormMainQuery.PassDataBetweenFormHandler(query_PassDataBetweenForm);
query.ShowDialog( );
if (_modelHeader.SHD001 != null && _modelHeader.SHD001 != string.Empty)
{
autoQuery( );
}
}
public HengDaEntity.FormMainHeader GetModel(DataRow row)
{
HengDaEntity.FormMainHeader _model = new HengDaEntity.FormMainHeader( );
if (row != null)
{
if (row["SHD001"] != null && row["SHD001"].ToString( ) != "")
{
_model.SHD001 = row["SHD001"].ToString( );
}
if (row["SHD002"] != null && row["SHD002"].ToString( ) != "")
{
_model.SHD002 = row["SHD002"].ToString( );
}
if (row["SHD003"] != null && row["SHD003"].ToString( ) != "")
{
_model.SHD003 = row["SHD003"].ToString( );
}
if (row["SHD004"] != null && row["SHD004"].ToString( ) != "")
{
_model.SHD004 = row["SHD004"].ToString( );
}
if (row["SHD005"] != null && row["SHD005"].ToString( ) != "")
{
_model.SHD005 = row["SHD005"].ToString( );
}
if (row["SHD006"] != null && row["SHD006"].ToString( ) != "")
{
_model.SHD006 = DateTime.Parse(row["SHD006"].ToString( ));
}
if (row["SHD007"] != null && row["SHD007"].ToString( ) != "")
{
_model.SHD007 = row["SHD007"].ToString( );
}
if (row["SHD008"] != null && row["SHD008"].ToString( ) != "")
{
_model.SHD008 = row["SHD008"].ToString( );
}
if (row["SHD009"] != null && row["SHD009"].ToString( ) != "")
{
_model.SHD009 = row["SHD009"].ToString( );
}
}
return(_model);
}
void UpdateMain(SqlCommand cmd, HengDaEntity.FormMainHeader _modelHeader, StringBuilder strSql, SqlTransaction tran, SqlConnection conn)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE HDSHD SET ");
strSql.Append("SHD002=@SHD002,");
strSql.Append("SHD003=@SHD003,");
strSql.Append("SHD004=@SHD004,");
strSql.Append("SHD005=@SHD005,");
strSql.Append("SHD006=@SHD006,");
strSql.Append("SHD007=@SHD007,");
strSql.Append("SHD008=@SHD008");
strSql.Append(" WHERE SHD001=@SHD001");
SqlParameter[] parameter =
{
new SqlParameter("@SHD001", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD002", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD003", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD004", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD005", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD006", SqlDbType.DateTime),
new SqlParameter("@SHD007", SqlDbType.NVarChar, 20),
new SqlParameter("@SHD008", SqlDbType.NVarChar, 20)
};
parameter[0].Value = _modelHeader.SHD001;
parameter[1].Value = _modelHeader.SHD002;
parameter[2].Value = _modelHeader.SHD003;
parameter[3].Value = _modelHeader.SHD004;
parameter[4].Value = _modelHeader.SHD005;
parameter[5].Value = _modelHeader.SHD006;
parameter[6].Value = _modelHeader.SHD007;
parameter[7].Value = _modelHeader.SHD008;
cmd.Parameters.Clear( );
SqlHelper.PrepareCommand(cmd, conn, tran, strSql.ToString( ), parameter);
cmd.CommandText = strSql.ToString( );
cmd.ExecuteNonQuery( );
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="tableOne">单身一</param>
/// <param name="tableTwo">单身二</param>
/// <param name="_modelHeader">单头</param>
/// <returns></returns>
public bool Save(DataTable tableOne, DataTable tableTwo, HengDaEntity.FormMainHeader _modelHeader)
{
return(_dao.Save(tableOne, tableTwo, _modelHeader));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="tableOne">单身一</param>
/// <param name="tableTwo">单身二</param>
/// <param name="_modelHeader">单头</param>
/// <returns></returns>
public bool Save(DataTable tableOne, DataTable tableTwo, HengDaEntity.FormMainHeader _modelHeader)
{
using (SqlConnection conn = new SqlConnection(SqlHelper.connstr))
{
conn.Open( );
SqlCommand cmd = new SqlCommand( );
cmd.Connection = conn;
SqlTransaction tran = conn.BeginTransaction( );
cmd.Transaction = tran;
try
{
ArrayList SQLString = new ArrayList( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM HDSHD WHERE SHD001=@SHD001");
SqlParameter[] paramete =
{
new SqlParameter("@SHD001", SqlDbType.NVarChar, 20)
};
paramete[0].Value = _modelHeader.SHD001;
if (SqlHelper.Exists(strSql.ToString( ), paramete) == true)
{
UpdateMain(cmd, _modelHeader, strSql, tran, conn);
}
else
{
AddMain(cmd, _modelHeader, strSql, tran, conn);
}
DataTable tableChoisOne;
if (tableOne != null && tableOne.Rows.Count > 0)
{
HengDaEntity.FormMainOne _modelOne = new HengDaEntity.FormMainOne( );
_modelOne.SHE001 = /*tableOne.Rows[0]["SHE001"].ToString( );*/ _modelHeader.SHD001;
tableChoisOne = SqlHelper.ExecuteDataTable("SELECT SHE002,SHE003 FROM HDSHE WHERE SHE001='" + _modelOne.SHE001 + "'");
for (int i = 0; i < tableOne.Rows.Count; i++)
{
_modelOne.SHE002 = tableOne.Rows[i]["SHE002"].ToString( );
_modelOne.SHE003 = tableOne.Rows[i]["SHE003"].ToString( );
_modelOne.SHE004 = tableOne.Rows[i]["SHE004"].ToString( );
_modelOne.SHE005 = tableOne.Rows[i]["SHE005"].ToString( );
_modelOne.SHE006 = tableOne.Rows[i]["SHE006"].ToString( );
_modelOne.SHE007 = string.IsNullOrEmpty(tableOne.Rows[i]["SHE007"].ToString( )) == true ? 0 : Convert.ToInt32(tableOne.Rows[i]["SHE007"].ToString( ));
_modelOne.SHE008 = string.IsNullOrEmpty(tableOne.Rows[i]["SHE008"].ToString( )) == true ? 0 : Convert.ToDecimal(tableOne.Rows[i]["SHE008"].ToString( ));
_modelOne.SHE009 = tableOne.Rows[i]["SHE009"].ToString( );
if (!string.IsNullOrEmpty(_modelOne.SHE004) && !string.IsNullOrEmpty(_modelOne.SHE005))
{
if (tableChoisOne.Select("SHE002='" + _modelOne.SHE002 + "' AND SHE003='" + _modelOne.SHE003 + "'").Length > 0)
{
UpdateOne(cmd, _modelOne, strSql, tran, conn);
}
else
{
AddOne(cmd, _modelOne, strSql, tran, conn);
}
}
}
if (tableChoisOne != null && tableChoisOne.Rows.Count > 0)
{
for (int k = 0; k < tableChoisOne.Rows.Count; k++)
{
_modelOne.SHE002 = tableChoisOne.Rows[k]["SHE002"].ToString( );
_modelOne.SHE003 = tableChoisOne.Rows[k]["SHE003"].ToString( );
if (tableOne.Select("SHE001='" + _modelOne.SHE001 + "' AND SHE002='" + _modelOne.SHE002 + "' AND SHE003='" + _modelOne.SHE003 + "'").Length < 1)
{
DeleteOne(cmd, _modelOne, strSql, tran, conn);
}
}
}
}
if (tableTwo != null && tableTwo.Rows.Count > 0)
{
HengDaEntity.FormMainTwo _modelTwo = new HengDaEntity.FormMainTwo( );
_modelTwo.SHF001 = /* tableTwo.Rows[0]["SHF001"].ToString( )*/ _modelHeader.SHD001;
tableChoisOne = SqlHelper.ExecuteDataTable("SELECT SHF002,SHF003 FROM HDSHF WHERE SHF001='" + _modelTwo.SHF001 + "'");
for (int i = 0; i < tableTwo.Rows.Count; i++)
{
_modelTwo.SHF002 = tableTwo.Rows[i]["SHF002"].ToString( );
_modelTwo.SHF003 = tableTwo.Rows[i]["SHF003"].ToString( );
_modelTwo.SHF004 = string.IsNullOrEmpty(tableTwo.Rows[i]["SHF004"].ToString( )) == true ? 0 : Convert.ToInt32(tableTwo.Rows[i]["SHF004"].ToString( ));
_modelTwo.SHF005 = string.IsNullOrEmpty(tableTwo.Rows[i]["SHF005"].ToString( )) == true ? 0 : Convert.ToDecimal(tableTwo.Rows[i]["SHF005"].ToString( ));
_modelTwo.SHF006 = string.IsNullOrEmpty(tableTwo.Rows[i]["SHF006"].ToString( )) == true ? 0 : Convert.ToInt32(tableTwo.Rows[i]["SHF006"].ToString( ));
_modelTwo.SHF007 = tableTwo.Rows[i]["SHF007"].ToString( );
_modelTwo.SHF008 = tableTwo.Rows[i]["SHF008"].ToString( );
if (!string.IsNullOrEmpty(_modelTwo.SHF007))
{
if (tableChoisOne.Select("SHF002='" + _modelTwo.SHF002 + "' AND SHF003='" + _modelTwo.SHF003 + "'").Length > 0)
{
UpdateTwo(cmd, _modelTwo, strSql, tran, conn);
}
else
{
AddTwo(cmd, _modelTwo, strSql, tran, conn);
}
}
}
if (tableChoisOne != null && tableChoisOne.Rows.Count > 0)
{
for (int k = 0; k < tableChoisOne.Rows.Count; k++)
{
_modelTwo.SHF002 = tableChoisOne.Rows[k]["SHF002"].ToString( );
_modelTwo.SHF003 = tableChoisOne.Rows[k]["SHF003"].ToString( );
if (tableTwo.Select("SHF001='" + _modelTwo.SHF001 + "' AND SHF002='" + _modelTwo.SHF002 + "' AND SHF003='" + _modelTwo.SHF003 + "'").Length < 1)
{
DeleteTwo(cmd, _modelTwo, strSql, tran, conn);
}
}
}
}
tran.Commit( );
return(true);
}
catch {
tran.Rollback( );
return(false);
}
finally
{
cmd.Dispose( );
conn.Close( );
}
}
}
