//////<summary> // ////增加一条数据 // ////</summary> //public int Add(SAInfo model) //{ // StringBuilder strSql = new StringBuilder(); // strSql.Append("insert into CAR_Table_SA("); // strSql.Append("sn_ptr,custCode,custName,recordDateTime,founderMaterilNo,custPartNo,cycleValue,happenAddress,LOT,ET,T,reason,mateialType,results,quantity,signDate,signingPerson,factoryName,discountPrice,discountAmount)"); // strSql.Append(" values ("); // strSql.Append("@sn_ptr,@custCode,@custName,@recordDateTime,@founderMaterilNo,@custPartNo,@cycleValue,@happenAddress,@LOT,@ET,@T,@reason,@mateialType,@results,@quantity,@signDate,@signingPerson,@factoryName,@discountPrice,@discountAmount)"); // strSql.Append(";select @@IDENTITY as id"); // SqlParameter[] parameters = { // new SqlParameter("@sn_ptr", SqlDbType.Int,4), // new SqlParameter("@custCode", SqlDbType.VarChar,10), // new SqlParameter("@custName", SqlDbType.VarChar,80), // new SqlParameter("@recordDateTime", SqlDbType.DateTime), // new SqlParameter("@founderMaterilNo", SqlDbType.VarChar,30), // new SqlParameter("@custPartNo", SqlDbType.VarChar,50), // new SqlParameter("@cycleValue", SqlDbType.VarChar,10), // new SqlParameter("@happenAddress", SqlDbType.VarChar,50), // new SqlParameter("@LOT", SqlDbType.VarChar,20), // new SqlParameter("@ET", SqlDbType.VarChar,20), // new SqlParameter("@T", SqlDbType.VarChar,20), // new SqlParameter("@reason", SqlDbType.VarChar,50), // new SqlParameter("@mateialType", SqlDbType.VarChar,10), // new SqlParameter("@results", SqlDbType.VarChar,10), // new SqlParameter("@quantity", SqlDbType.Float,8), // new SqlParameter("@signDate", SqlDbType.DateTime), // new SqlParameter("@signingPerson", SqlDbType.VarChar,20), // new SqlParameter("@factoryName", SqlDbType.VarChar,10), // new SqlParameter("@discountPrice", SqlDbType.Float,8), // new SqlParameter("@discountAmount", SqlDbType.Float,8)}; // parameters[0].Value = model.sn_ptr; // parameters[1].Value = model.custCode; // parameters[2].Value = model.custName; // parameters[3].Value = model.recordDateTime; // parameters[4].Value = model.founderMaterilNo; // parameters[5].Value = model.custPartNo; // parameters[6].Value = model.cycleValue; // parameters[7].Value = model.happenAddress; // parameters[8].Value = model.LOT; // parameters[9].Value = model.ET; // parameters[10].Value = model.T; // parameters[11].Value = model.reason; // parameters[12].Value = model.mateialType; // parameters[13].Value = model.results; // parameters[14].Value = model.quantity; // parameters[15].Value = model.signDate; // parameters[16].Value = model.signingPerson; // parameters[17].Value = model.factoryName; // parameters[18].Value = model.discountPrice; // parameters[19].Value = model.discountAmount; // System.Data.SqlClient.SqlCommand cmd = GenCommand(strSql.ToString(), CommandType.Text); // for (int i = 0; i < parameters.Length; i++) // { // cmd.Parameters.Add(parameters[i]); // } // DataTable tb = new DataTable(); // FounderTecInfoSys.Common.SQLBase.ERPSQLManager.GetInstance().GetSQL(tb, cmd); // if (tb.Rows.Count > 0) // { // return Convert.ToInt32(tb.Rows[0][0].ToString()); // } // else // { // return 0; // } //} #endregion /// <summary> /// 增加一条数据 /// </summary> public int Add(SAList model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@rkey", SqlDbType.Int, 4), new SqlParameter("@sn_ptr", SqlDbType.Int, 4), new SqlParameter("@custCode", SqlDbType.VarChar, 10), new SqlParameter("@custName", SqlDbType.VarChar, 80), new SqlParameter("@recordDateTime", SqlDbType.DateTime), new SqlParameter("@founderMaterilNo", SqlDbType.VarChar, 30), new SqlParameter("@custPartNo", SqlDbType.VarChar, 50), new SqlParameter("@cycleValue", SqlDbType.VarChar, 10), new SqlParameter("@happenAddress", SqlDbType.VarChar, 50), new SqlParameter("@LOT", SqlDbType.VarChar, 20), new SqlParameter("@ET", SqlDbType.VarChar, 20), new SqlParameter("@T", SqlDbType.VarChar, 20), new SqlParameter("@reason", SqlDbType.VarChar, 50), new SqlParameter("@mateialType", SqlDbType.VarChar, 10), new SqlParameter("@results", SqlDbType.VarChar, 10), new SqlParameter("@quantity", SqlDbType.Float, 8), new SqlParameter("@signDate", SqlDbType.DateTime), new SqlParameter("@signingPerson", SqlDbType.VarChar, 20), new SqlParameter("@factoryName", SqlDbType.VarChar, 10), new SqlParameter("@discountPrice", SqlDbType.Float, 8), new SqlParameter("@discountAmount", SqlDbType.Float, 8) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.sn_ptr; parameters[2].Value = model.custCode; parameters[3].Value = model.custName; parameters[4].Value = model.recordDateTime; parameters[5].Value = model.founderMaterilNo; parameters[6].Value = model.custPartNo; parameters[7].Value = model.cycleValue; parameters[8].Value = model.happenAddress; parameters[9].Value = model.LOT; parameters[10].Value = model.ET; parameters[11].Value = model.T; parameters[12].Value = model.reason; parameters[13].Value = model.mateialType; parameters[14].Value = model.results; parameters[15].Value = model.quantity; parameters[16].Value = model.signDate; parameters[17].Value = model.signingPerson; parameters[18].Value = model.factoryName; parameters[19].Value = model.discountPrice; parameters[20].Value = model.discountAmount; SqlCommand cmd = GenCommand("UP_CAR_Table_SAList_ADD", CommandType.StoredProcedure); foreach (SqlParameter pr in parameters) { cmd.Parameters.Add(pr); } return(FounderTecInfoSys.Common.SQLBase.ERPSQLManager.GetInstance().ExecuteStoredProcedure(cmd)); }
protected override void LoadContent() { background = Statics.CONTENT.Load <Texture2D>("Images/Backgrounds/diahinh"); usersList.Add(new Demen(Game.Content.Load <Texture2D>(@"Images\right"), new Point(0, 0), 0, new Vector2(100, 40), 2, 10, 8, 1, 1, true, 3000, 2 / 3, true, 1, this, Game.Content.Load <Texture2D>(@"Blood\blood1"))); SAList.Add(new Entities.Rua1(Game.Content.Load <Texture2D>(@"Images/Entities/Rua/right_dichuyen"), new Point(0, 0), 0, new Vector2(700, 500), (float)0.2, 10, 8, 1, 1, false, 3500, 2 / 3, true, 1, this, Game.Content.Load <Texture2D>(@"Blood\blood1"), 300)); SAList.Add(new Entities.Rua1(Game.Content.Load <Texture2D>(@"Images/Entities/Rua/right_dichuyen"), new Point(0, 0), 0, new Vector2(700, 500), (float)0.2, 10, 8, 1, 1, false, 3500, 2 / 3, true, 1, this, Game.Content.Load <Texture2D>(@"Blood\blood1"), 300)); enemyList.Add(new Entities.Rua(Game.Content.Load <Texture2D>(@"Images/Entities/Rua/right_dichuyen"), new Point(0, 0), 0, new Vector2(700, 500), (float)0.2, 10, 8, 1, 1, false, 3500, 2 / 3, true, 1, this, Game.Content.Load <Texture2D>(@"Blood\blood1"), 300)); enemyList.Add(new Entities.Rua(Game.Content.Load <Texture2D>(@"Images/Entities/Rua/right_dichuyen"), new Point(0, 0), 0, new Vector2(700, 300), (float)0.2, 10, 8, 1, 1, false, 3500, 2 / 3, true, 1, this, Game.Content.Load <Texture2D>(@"Blood\blood1"), 300)); foreach (Entities.Character s in usersList) { myCharacterList.Add(s); } foreach (Entities.Character s in SAList) { myCharacterList.Add(s); } foreach (Entities.Character s in myCharacterList) { charactersList.Add(s); } foreach (Entities.Character s in enemyList) { charactersList.Add(s); } base.LoadContent(); }
private int Writelog(int sn_ptr) { DataRow[] rows = tb_SA.Select("custName <>'' and custCode <> ''"); SAListBLL salistBll = new SAListBLL(CurrentFactoryID); salistBll.DeteleByKey(did); for (int b = 0; b < rows.Length; b++) { SAList sa = new SAList(); sa.sn_ptr = sn_ptr; sa.custCode = tb_SA.Rows[b]["custCode"].ToString(); sa.custName = tb_SA.Rows[b]["custName"].ToString(); try { sa.recordDateTime = Convert.ToDateTime(tb_SA.Rows[b]["recordDateTime"].ToString()); } catch { } sa.founderMaterilNo = tb_SA.Rows[b]["founderMaterilNo"].ToString(); sa.custPartNo = tb_SA.Rows[b]["custPartNo"].ToString(); sa.cycleValue = tb_SA.Rows[b]["cycleValue"].ToString(); sa.happenAddress = tb_SA.Rows[b]["happenAddress"].ToString(); sa.LOT = tb_SA.Rows[b]["LOT"].ToString(); sa.ET = tb_SA.Rows[b]["ET"].ToString(); sa.T = tb_SA.Rows[b]["T"].ToString(); sa.reason = tb_SA.Rows[b]["reason"].ToString(); sa.mateialType = tb_SA.Rows[b]["mateialType"].ToString(); sa.results = tb_SA.Rows[b]["results"].ToString(); try { sa.quantity = decimal.Parse(tb_SA.Rows[b]["quantity"].ToString()); } catch { sa.quantity = 0; } try { sa.signDate = Convert.ToDateTime(tb_SA.Rows[b]["signDate"].ToString()); } catch { } sa.signingPerson = tb_SA.Rows[b]["signingPerson"].ToString(); sa.factoryName = tb_SA.Rows[b]["factoryName"].ToString(); try { sa.discountPrice = decimal.Parse(tb_SA.Rows[b]["discountPrice"].ToString()); } catch { } try { sa.discountAmount = decimal.Parse(tb_SA.Rows[b]["discountAmount"].ToString()); } catch { } salistBll.Add(sa); } CARLogBLL logBll = new CARLogBLL(CurrentFactoryID); DataTable tb_temp = new DataTable(); tb_temp = logBll.GetDataSet("select rkey from CAR_Table_LOG where sn_type = 'SA' and SN_PTR = " + sn_ptr.ToString()); int a = 0; for (int i = 0; i < tb_temp.Rows.Count; i++) { a = logBll.DelData(int.Parse(tb_temp.Rows[i][0].ToString())); if (a != 0) { return(-1); } } if (ApprovalTable.Rows.Count > 0) { for (int j = 0; j < ApprovalTable.Rows.Count; j++) { LogInfo logInfo = new LogInfo(); logInfo.sn_ptr = sn_ptr; logInfo.sn_type = "SA"; logInfo.sp_total_step = ApprovalTable.Rows.Count; if (j == 0) { logInfo.sp_start_date = DateTime.Now; //logInfo.sp_end_date } logInfo.sp_type = 1; logInfo.sp_step = j + 1; logInfo.sp_user = ApprovalTable.Rows[j][2].ToString(); //logInfo.sp_content logInfo.status = 0; a = logBll.AddData(logInfo); if (a != 0) { return(-1); } } } return(0); }
public void Update(SAList model) { SAListDAL dd = new SAListDAL(_factoryID); dd.Update(model); }
public int Add(SAList model) { SAListDAL dd = new SAListDAL(_factoryID); return(dd.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SAList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CAR_Table_SAList set "); strSql.Append("sn_ptr=@sn_ptr,"); strSql.Append("custCode=@custCode,"); strSql.Append("custName=@custName,"); strSql.Append("recordDateTime=@recordDateTime,"); strSql.Append("founderMaterilNo=@founderMaterilNo,"); strSql.Append("custPartNo=@custPartNo,"); strSql.Append("cycleValue=@cycleValue,"); strSql.Append("happenAddress=@happenAddress,"); strSql.Append("LOT=@LOT,"); strSql.Append("ET=@ET,"); strSql.Append("T=@T,"); strSql.Append("reason=@reason,"); strSql.Append("mateialType=@mateialType,"); strSql.Append("results=@results,"); strSql.Append("quantity=@quantity,"); strSql.Append("signDate=@signDate,"); strSql.Append("signingPerson=@signingPerson,"); strSql.Append("factoryName=@factoryName,"); strSql.Append("discountPrice=@discountPrice,"); strSql.Append("discountAmount=@discountAmount"); strSql.Append(" where rkey=@rkey "); SqlParameter[] parameters = { new SqlParameter("@rkey", SqlDbType.Int, 4), new SqlParameter("@sn_ptr", SqlDbType.Int, 4), new SqlParameter("@custCode", SqlDbType.VarChar, 10), new SqlParameter("@custName", SqlDbType.VarChar, 80), new SqlParameter("@recordDateTime", SqlDbType.DateTime), new SqlParameter("@founderMaterilNo", SqlDbType.VarChar, 30), new SqlParameter("@custPartNo", SqlDbType.VarChar, 50), new SqlParameter("@cycleValue", SqlDbType.VarChar, 10), new SqlParameter("@happenAddress", SqlDbType.VarChar, 50), new SqlParameter("@LOT", SqlDbType.VarChar, 20), new SqlParameter("@ET", SqlDbType.VarChar, 20), new SqlParameter("@T", SqlDbType.VarChar, 20), new SqlParameter("@reason", SqlDbType.VarChar, 50), new SqlParameter("@mateialType", SqlDbType.VarChar, 10), new SqlParameter("@results", SqlDbType.VarChar, 10), new SqlParameter("@quantity", SqlDbType.Float, 8), new SqlParameter("@signDate", SqlDbType.DateTime), new SqlParameter("@signingPerson", SqlDbType.VarChar, 20), new SqlParameter("@factoryName", SqlDbType.VarChar, 10), new SqlParameter("@discountPrice", SqlDbType.Float, 8), new SqlParameter("@discountAmount", SqlDbType.Float, 8) }; parameters[0].Value = model.rkey; parameters[1].Value = model.sn_ptr; parameters[2].Value = model.custCode; parameters[3].Value = model.custName; parameters[4].Value = model.recordDateTime; parameters[5].Value = model.founderMaterilNo; parameters[6].Value = model.custPartNo; parameters[7].Value = model.cycleValue; parameters[8].Value = model.happenAddress; parameters[9].Value = model.LOT; parameters[10].Value = model.ET; parameters[11].Value = model.T; parameters[12].Value = model.reason; parameters[13].Value = model.mateialType; parameters[14].Value = model.results; parameters[15].Value = model.quantity; parameters[16].Value = model.signDate; parameters[17].Value = model.signingPerson; parameters[18].Value = model.factoryName; parameters[19].Value = model.discountPrice; parameters[20].Value = model.discountAmount; SqlCommand cmd = GenCommand(strSql.ToString(), CommandType.Text); foreach (SqlParameter pr in parameters) { cmd.Parameters.Add(pr); } FounderTecInfoSys.Common.SQLBase.ERPSQLManager.GetInstance().ExecuteStoredProcedure(cmd); }