/// <summary> /// 同填表人,同流水只能有一张表 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool ExistsUserAndNum(MulaolaoLibrary.GongXuGongZiLibrary model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT COUNT(1) FROM R_PQR"); strSql.Append(" WHERE DS01=@DS01 AND DS11=@DS11 AND DS21!=@DS21"); SqlParameter [] parameter = { new SqlParameter("@DS01", SqlDbType.NVarChar), new SqlParameter("@DS11", SqlDbType.NVarChar), new SqlParameter("@DS21", SqlDbType.NVarChar) }; parameter [0].Value = model.DS01; parameter [1].Value = model.DS11; parameter [2].Value = model.DS21; return(SqlHelper.Exists(strSql.ToString( ), parameter)); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateOther(MulaolaoLibrary.GongXuGongZiLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQR SET"); strSql.AppendFormat(" DS10='{0}',", model.DS10); strSql.AppendFormat(" DS11='{0}',", model.DS11); strSql.AppendFormat(" DS12='{0}',", model.DS12); strSql.AppendFormat(" DS13='{0}',", model.DS13); strSql.AppendFormat(" DS14='{0}',", model.DS14); strSql.AppendFormat(" DS01='{0}',", model.DS01); strSql.AppendFormat(" DS22='{0}',", model.DS22); strSql.AppendFormat(" DS24='{0}',", model.DS24); strSql.AppendFormat(" DS25='{0}',", model.DS25); strSql.AppendFormat(" DS26='{0}',", model.DS26); strSql.AppendFormat(" DS27='{0}'", model.DS27); strSql.AppendFormat(" WHERE DS21='{0}'", model.DS21); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.DS21, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateWei(MulaolaoLibrary.GongXuGongZiLibrary model) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQR SET"); strSql.AppendFormat(" DS10='{0}',", model.DS10); strSql.AppendFormat(" DS11='{0}',", model.DS11); strSql.AppendFormat(" DS12='{0}',", model.DS12); strSql.AppendFormat(" DS13='{0}',", model.DS13); strSql.AppendFormat(" DS14='{0}',", model.DS14); strSql.AppendFormat(" DS19='{0}',", model.DS19); strSql.AppendFormat(" DS20='{0}',", model.DS20); strSql.AppendFormat(" DS01='{0}',", model.DS01); strSql.AppendFormat(" DS22='{0}',", model.DS22); strSql.AppendFormat(" DS24='{0}',", model.DS24); strSql.AppendFormat(" DS25='{0}',", model.DS25); strSql.AppendFormat(" DS26='{0}',", model.DS26); strSql.AppendFormat(" DS27='{0}'", model.DS27); strSql.AppendFormat(" WHERE DS21='{0}'", model.DS21); SQLString.Add(strSql.ToString( )); return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 获取一个实例对象 /// </summary> /// <param name="row"></param> /// <returns></returns> public MulaolaoLibrary.GongXuGongZiLibrary GetDataRow(DataRow row) { MulaolaoLibrary.GongXuGongZiLibrary model = new MulaolaoLibrary.GongXuGongZiLibrary( ); if (row != null) { if (row["idx"] != null && row["idx"].ToString( ) != "") { model.Idx = int.Parse(row["idx"].ToString( )); } if (row["DS01"] != null && row["DS01"].ToString( ) != "") { model.DS01 = row["DS01"].ToString( ); } if (row["DS02"] != null && row["DS02"].ToString( ) != "") { model.DS02 = row["DS02"].ToString( ); } if (row["DS03"] != null && row["DS03"].ToString( ) != "") { model.DS03 = row["DS03"].ToString( ); } if (row["DS04"] != null && row["DS04"].ToString( ) != "") { model.DS04 = row["DS04"].ToString( ); } if (row["DS05"] != null && row["DS05"].ToString( ) != "") { model.DS05 = long.Parse(row["DS05"].ToString( )); } if (row["DS06"] != null && row["DS06"].ToString( ) != "") { model.DS06 = long.Parse(row["DS06"].ToString( )); } //if ( row["DS07"] != null && row["DS07"].ToString( ) != "" ) // model.DS07 = decimal.Parse( row["DS07"].ToString( ) ); if (row["DS08"] != null && row["DS08"].ToString( ) != "") { model.DS08 = long.Parse(row["DS08"].ToString( )); } if (row["DS09"] != null && row["DS09"].ToString( ) != "") { model.DS09 = row["DS09"].ToString( ); } if (row["DS10"] != null && row["DS10"].ToString( ) != "") { model.DS10 = row["DS10"].ToString( ); } if (row["DS11"] != null && row["DS11"].ToString( ) != "") { model.DS11 = row["DS11"].ToString( ); } if (row["DS12"] != null && row["DS12"].ToString( ) != "") { model.DS12 = DateTime.Parse(row["DS12"].ToString( )); } if (row["DS13"] != null && row["DS13"].ToString( ) != "") { model.DS13 = row["DS13"].ToString( ); } if (row["DS14"] != null && row["DS14"].ToString( ) != "") { model.DS14 = DateTime.Parse(row["DS14"].ToString( )); } //if ( row["DS15"] != null && row["DS15"].ToString( ) != "" ) // model.DS15 = decimal.Parse( row["DS15"].ToString( ) ); if (row["DS16"] != null && row["DS16"].ToString( ) != "") { model.DS16 = long.Parse(row["DS16"].ToString( )); } if (row["DS17"] != null && row["DS17"].ToString( ) != "") { model.DS17 = row["DS17"].ToString( ); } if (row["DS18"] != null && row["DS18"].ToString( ) != "") { model.DS18 = decimal.Parse(row["DS18"].ToString( )); } if (row["DS19"] != null && row["DS19"].ToString( ) != "") { model.DS19 = row["DS19"].ToString( ); } if (row["DS20"] != null && row["DS20"].ToString( ) != "") { model.DS20 = row["DS20"].ToString( ); } if (row["DS21"] != null && row["DS21"].ToString( ) != "") { model.DS21 = row["DS21"].ToString( ); } if (row["DS22"] != null && row["DS22"].ToString( ) != "") { model.DS22 = row["DS22"].ToString( ); } if (row["DS24"] != null && row["DS24"].ToString( ) != "") { model.DS24 = row["DS24"].ToString( ); } if (row["DS25"] != null && row["DS25"].ToString( ) != "") { model.DS25 = long.Parse(row["DS25"].ToString( )); } if (row["DS26"] != null && row["DS26"].ToString( ) != "") { model.DS26 = row["DS26"].ToString( ); } if (row["DS27"] != null && row["DS27"].ToString( ) != "") { model.DS27 = DateTime.Parse(row["DS27"].ToString( )); } if (row["DS28"] != null && row["DS28"].ToString( ) != "") { model.DS28 = int.Parse(row["DS28"].ToString( )); } if (row["DS29"] != null && row["DS29"].ToString( ) != "") { model.DS29 = int.Parse(row["DS29"].ToString( )); } } return(model); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateOther(MulaolaoLibrary.GongXuGongZiLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { return(dao.UpdateOther(model, tableNum, tableName, logins, dtOne, stateOf, stateOfOdd)); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateWei(MulaolaoLibrary.GongXuGongZiLibrary model) { return(dao.UpdateWei(model)); }
/// <summary> /// 同填表人,同流水只能有一张表 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool ExistsUserAndNum(MulaolaoLibrary.GongXuGongZiLibrary model) { return(dao.ExistsUserAndNum(model)); }
/// <summary> /// 插入一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool InsertGen(MulaolaoLibrary.GongXuGongZiLibrary model) { return(dao.InsertGen(model)); }