//////<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);
}
