/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model</param> public int AddRecord(OtherOutInBillData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("set nocount on; "); strSql.Append("insert into OtherOutInBill("); strSql.Append(@"SAPDocEntry,SAPStatus,SAPOriginNum,CustName,SAPCardCode,SAPLineNum,InstantState,StockUpBillNO,Mark)"); strSql.Append(" values ("); strSql.Append(@"@SAPDocEntry,@SAPStatus,@SAPOriginNum,@CustName,@SAPCardCode,@SAPLineNum,@InstantState,@StockUpBillNO,@Mark)"); strSql.Append("; select @@identity; set nocount off; "); SqlParameter[] parameters = { new SqlParameter("@SAPDocEntry", SqlDbType.NVarChar,50), new SqlParameter("@SAPStatus", SqlDbType.VarChar,10), new SqlParameter("@SAPOriginNum", SqlDbType.Int), new SqlParameter("@CustName", SqlDbType.NVarChar,50), new SqlParameter("@SAPCardCode", SqlDbType.NVarChar,50), new SqlParameter("@SAPLineNum", SqlDbType.Int), new SqlParameter("@InstantState", SqlDbType.NChar,10), new SqlParameter("@StockUpBillNO", SqlDbType.NVarChar,50), new SqlParameter("@Mark", SqlDbType.NVarChar,500) }; parameters[0].Value = model.SAPDocEntry; parameters[1].Value = model.SAPStatus; parameters[2].Value = model.SAPOriginNum; parameters[3].Value = model.CustName; parameters[4].Value = model.SAPCardCode; parameters[5].Value = model.SAPLineNum; parameters[6].Value = model.InstantState; parameters[7].Value = model.StockUpBillNO; parameters[8].Value = model.Mark; int id = 0; try { object ret = SqlHelper.ExecuteScalar(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ret != null && ret != DBNull.Value) { id = Convert.ToInt32(ret); } } catch (Exception ex) { throw ex; } return id; }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(OtherOutInBillData model) { bool ret = false; StringBuilder strSql = new StringBuilder(); strSql.Append("update OtherOutInBill set "); strSql.Append("SAPDocEntry=@SAPDocEntry,"); strSql.Append("SAPStatus=@SAPStatus,"); strSql.Append("SAPOriginNum=@SAPOriginNum,"); strSql.Append("CustName=@CustName,"); strSql.Append("SAPCardCode=@SAPCardCode,"); strSql.Append("SAPLineNum=@SAPLineNum,"); strSql.Append("InstantState=@InstantState,"); strSql.Append("StockUpBillNO=@StockUpBillNO,"); strSql.Append("Mark=@Mark"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.BigInt), new SqlParameter("@SAPDocEntry", SqlDbType.NVarChar,50), new SqlParameter("@SAPStatus", SqlDbType.VarChar,10), new SqlParameter("@SAPOriginNum", SqlDbType.Int), new SqlParameter("@CustName", SqlDbType.NVarChar,50), new SqlParameter("@SAPCardCode", SqlDbType.NVarChar,50), new SqlParameter("@SAPLineNum", SqlDbType.Int), new SqlParameter("@InstantState", SqlDbType.NChar,10), new SqlParameter("@StockUpBillNO", SqlDbType.NVarChar,50), new SqlParameter("@Mark", SqlDbType.NVarChar,500) }; parameters[0].Value = model.id; parameters[1].Value = model.SAPDocEntry; parameters[2].Value = model.SAPStatus; parameters[3].Value = model.SAPOriginNum; parameters[4].Value = model.CustName; parameters[5].Value = model.SAPCardCode; parameters[6].Value = model.SAPLineNum; parameters[7].Value = model.InstantState; parameters[8].Value = model.StockUpBillNO; parameters[9].Value = model.Mark; try { SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); ret = true; } catch (Exception ex) { throw ex; } return ret; }
/// <summary> /// 得到一个model /// </summary> /// <param name="id">主键值</param> /// <returns>model</returns> public OtherOutInBillData GetModel(long id) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select id,SAPDocEntry,SAPStatus,SAPOriginNum,CustName,SAPCardCode,SAPLineNum,InstantState,StockUpBillNO,Mark from OtherOutInBill"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.BigInt) }; parameters[0].Value = id; OtherOutInBillData model = new OtherOutInBillData(); DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; if (row["id"] != DBNull.Value) { model.id = Convert.ToInt64(row["id"]); } if (row["SAPDocEntry"] != DBNull.Value) { model.SAPDocEntry = Convert.ToString(row["SAPDocEntry"]); } if (row["SAPStatus"] != DBNull.Value) { model.SAPStatus = Convert.ToString(row["SAPStatus"]); } if (row["SAPOriginNum"] != DBNull.Value) { model.SAPOriginNum = Convert.ToInt32(row["SAPOriginNum"]); } if (row["CustName"] != DBNull.Value) { model.CustName = Convert.ToString(row["CustName"]); } if (row["SAPCardCode"] != DBNull.Value) { model.SAPCardCode = Convert.ToString(row["SAPCardCode"]); } if (row["SAPLineNum"] != DBNull.Value) { model.SAPLineNum = Convert.ToInt32(row["SAPLineNum"]); } if (row["InstantState"] != DBNull.Value) { model.InstantState = Convert.ToString(row["InstantState"]); } if (row["StockUpBillNO"] != DBNull.Value) { model.StockUpBillNO = Convert.ToString(row["StockUpBillNO"]); } if (row["Mark"] != DBNull.Value) { model.Mark = Convert.ToString(row["Mark"]); } return model; } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(OtherOutInBillData model) { return this.therOutInBillDB.ModifyRecord(model); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model</param> public int AddRecord(OtherOutInBillData model) { return this.therOutInBillDB.AddRecord(model); }
/// <summary> /// 更新一条"其他出入库BILL表"信息 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(OtherOutInBillData model) { bool ret = false; SqlTransaction trans = null; try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TransModify"); this.therOutInBillBB.Transaction = trans; this.errorDiaryBB.Transaction = trans; this.operatDiaryBB.Transaction = trans; } this.therOutInBillBB.ModifyRecord(model); SOperatDiaryData operatDiaryData = new SOperatDiaryData(); operatDiaryData.empId = this.empId; operatDiaryData.functionId = ""; operatDiaryData.recordId = model.id.ToString(); operatDiaryData.operateContent = "其他出入库BILL表修改一条id为“" + model.id.ToString() + "”的记录"; this.operatDiaryBB.AddRecord(operatDiaryData); if (this.transaction == null) trans.Commit(); ret = true; } catch (Exception ex) { if (this.transaction == null) trans.Rollback("TransModify"); SErrorDiaryData errorDiaryData = new SErrorDiaryData(); errorDiaryData.empId = this.empId; errorDiaryData.functionId = ""; errorDiaryData.errorText = "其他出入库BILL表修改记录“" + model.id.ToString() + "”时报错:" + ex.Message; this.errorDiaryBB.AddRecord(errorDiaryData); throw ex; } finally { } return ret; }
/// <summary> /// 增加一条"其他出入库BILL表"信息 /// </summary> /// <param name="model">model</param> public int AddRecord(OtherOutInBillData model) { int id = 0; SqlTransaction trans = null; try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TransAdd"); this.therOutInBillBB.Transaction = trans; this.errorDiaryBB.Transaction = trans; this.operatDiaryBB.Transaction = trans; } id = this.therOutInBillBB.AddRecord(model); SOperatDiaryData operatDiaryData = new SOperatDiaryData(); operatDiaryData.empId = this.empId; operatDiaryData.functionId = ""; operatDiaryData.recordId = id.ToString(); operatDiaryData.operateContent = "其他出入库BILL表增加一条id为“" + id.ToString() + "”的记录"; this.operatDiaryBB.AddRecord(operatDiaryData); if (this.transaction == null) trans.Commit(); } catch (Exception ex) { if (this.transaction == null) trans.Rollback("TransAdd"); SErrorDiaryData errorDiaryData = new SErrorDiaryData(); errorDiaryData.empId = this.empId; errorDiaryData.functionId = ""; errorDiaryData.errorText = "其他出入库BILL表增加记录时报错:" + ex.Message; this.errorDiaryBB.AddRecord(errorDiaryData); throw ex; } finally { } return id; }