public string AddOf(MulaolaoLibrary.MaterialPurchaseCompariaseLibrary _model)
        {
            StringBuilder strSql = new StringBuilder( );

            strSql.Append("INSERT INTO R_PQAU (");
            strSql.Append("AU001,AU002,AU003,AU004)");
            strSql.Append(" VALUES (");
            strSql.AppendFormat("'{0}','{1}','{2}','{3}')", _model.AU001, _model.AU002, _model.AU003, _model.AU004);

            return(strSql.ToString( ));
        }
        public string UpdateOf(MulaolaoLibrary.MaterialPurchaseCompariaseLibrary _model)
        {
            StringBuilder strSql = new StringBuilder( );

            strSql.Append("UPDATE R_PQAU SET ");
            strSql.AppendFormat("AU002='{0}',", _model.AU002);
            strSql.AppendFormat("AU003='{0}',", _model.AU003);
            strSql.AppendFormat("AU004='{0}'", _model.AU004);
            strSql.AppendFormat(" WHERE AU001='{0}'", _model.AU001);

            return(strSql.ToString( ));
        }
        /// <summary>
        /// 生成数据
        /// </summary>
        /// <param name="_model"></param>
        /// <returns></returns>
        public bool Generate(MulaolaoLibrary.MaterialPurchaseCompariaseLibrary _model, string year)
        {
            ArrayList SQLString = new ArrayList( );
            DataTable da        = new DataTable( );

            da = GetDataTableOfCost(year.Substring(2, 2));
            if (da != null && da.Rows.Count > 0)
            {
                _model.AU001 = "R_241";
                _model.AU002 = string.IsNullOrEmpty(da.Rows[0]["U14"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[0]["U14"].ToString( ));
                _model.AU003 = string.IsNullOrEmpty(da.Rows[0]["U16"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[0]["U16"].ToString( ));
                _model.AU004 = string.IsNullOrEmpty(da.Rows[0]["U17"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[0]["U17"].ToString( ));
                if (Exists(_model.AU001))
                {
                    SQLString.Add(UpdateOf(_model));
                }
                else
                {
                    SQLString.Add(AddOf(_model));
                }
            }
            else
            {
                return(false);
            }

            if (SqlHelper.ExecuteSqlTran(SQLString))
            {
                SQLString.Clear( );
                _model.AU001 = "R_526";
                _model.AU002 = _model.AU003 = 0;
                da           = GetDataTableOfCount(year.Substring(2, 2));
                if (da != null && da.Rows.Count > 0)
                {
                    _model.AU003 = string.IsNullOrEmpty(da.Rows [0] ["R"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [0] ["R"].ToString( ));
                }

                da = GetDataTableOfY(year.Substring(2, 2));
                if (da != null && da.Rows.Count > 0)
                {
                    _model.AU002 = string.IsNullOrEmpty(da.Rows [0] ["R"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [0] ["R"].ToString( ));
                }
                _model.AU004 = _model.AU002 - _model.AU003;
                if (Exists(_model.AU001))
                {
                    SQLString.Add(UpdateOf(_model));
                }
                else
                {
                    SQLString.Add(AddOf(_model));
                }
            }

            if (SqlHelper.ExecuteSqlTran(SQLString))
            {
                SQLString.Clear( );
                GetDataTableOfPayMent(year.Substring(2, 2));
                _model.AU001 = "R_231";
                _model.AU002 = Convert.ToInt32(sumOne);
                _model.AU003 = Convert.ToInt32(sumTwo);
                _model.AU004 = _model.AU002 - _model.AU003;
                if (Exists(_model.AU001))
                {
                    SQLString.Add(UpdateOf(_model));
                }
                else
                {
                    SQLString.Add(AddOf(_model));
                }
            }

            if (SqlHelper.ExecuteSqlTran(SQLString))
            {
                SQLString.Clear( );
                GetDataTableOfPayMent323(year.Substring(2, 2));
                _model.AU001 = "R_323";
                _model.AU002 = Convert.ToInt32(sumOne);
                _model.AU003 = Convert.ToInt32(sumTwo);
                _model.AU004 = _model.AU002 - _model.AU003;
                if (Exists(_model.AU001))
                {
                    SQLString.Add(UpdateOf(_model));
                }
                else
                {
                    SQLString.Add(AddOf(_model));
                }
            }

            if (SqlHelper.ExecuteSqlTran(SQLString))
            {
                SQLString.Clear( );
                GetDataTableOfPayMent243(year.Substring(2, 2));
                _model.AU001 = "R_243";
                _model.AU002 = Convert.ToInt32(sumOne);
                _model.AU003 = Convert.ToInt32(sumTwo);
                _model.AU004 = _model.AU002 - _model.AU003;
                if (Exists(_model.AU001))
                {
                    SQLString.Add(UpdateOf(_model));
                }
                else
                {
                    SQLString.Add(AddOf(_model));
                }
            }



            return(SqlHelper.ExecuteSqlTran(SQLString));
        }
 /// <summary>
 /// 生成数据
 /// </summary>
 /// <param name="_model"></param>
 /// <returns></returns>
 public bool Generate(MulaolaoLibrary.MaterialPurchaseCompariaseLibrary _model, string year)
 {
     return(_dao.Generate(_model, year));
 }