示例#1
0
        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( ));
        }
示例#2
0
        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( ));
        }
示例#3
0
        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( );
        }
示例#4
0
        /// <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));
        }
示例#5
0
 /// <summary>
 /// 保存数据源
 /// </summary>
 /// <param name="_model"></param>
 /// <returns></returns>
 public bool AddTableOfSql(YiGeEntiry.VersionEntity _model)
 {
     return(_dao.AddTableOfSql(_model));
 }