public string AddOfSql(YiGeEntiry.VersionEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO DJSJY (");
strSql.Append("DJ002,DJ003,DJ004,DJ005,DJ006,DJ007)");
strSql.Append(" VALUES (");
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}')", _model.DJ002, _model.DJ003, _model.DJ004, _model.DJ005, _model.DJ006, _model.DJ007);
return(strSql.ToString( ));
}
public string UpdateOfSql(YiGeEntiry.VersionEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE DJSJY SET ");
strSql.AppendFormat("DJ003='{0}',", _model.DJ003);
strSql.AppendFormat("DJ004='{0}',", _model.DJ004);
strSql.AppendFormat("DJ005='{0}',", _model.DJ005);
strSql.AppendFormat("DJ006='{0}',", _model.DJ006);
strSql.AppendFormat("DJ007='{0}'", _model.DJ007);
strSql.AppendFormat(" WHERE DJ002='{0}'", _model.DJ002);
return(strSql.ToString( ));
}
public Form1( )
{
InitializeComponent( );
_bll = new YiGeBll.Bll.VerBll( );
_model = new YiGeEntiry.VersionEntity( );
formQuery = new YiGeQuery.Form1Query( );
formQueryOne = new YiGeQuery.FormOneQuery( );
formQueryTwo = new YiGeQuery.FormTwoQuery( );
formQueryTre = new YiGeQuery.FormTreQuery( );
formQueryFor = new YiGeQuery.FormForQuery( );
formQueryFiv = new YiGeQuery.FormFivQuery( );
formQuerySix = new YiGeQuery.FormSxiQuery( );
formQuerySev = new YiGeQuery.FormSevQuery( );
}
/// <summary>
/// 保存数据源
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool AddTableOfSql(YiGeEntiry.VersionEntity _model)
{
ArrayList SQLString = new ArrayList( );
if (ExistsSql(_model.DJ002))
{
SQLString.Add(UpdateOfSql(_model));
}
else
{
SQLString.Add(AddOfSql(_model));
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 保存数据源
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool AddTableOfSql(YiGeEntiry.VersionEntity _model)
{
return(_dao.AddTableOfSql(_model));
}