/// <summary> /// ����һ������ /// </summary> public void Add(Galant.Model.products model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into products("); strSql.Append("Product_Name,Alias,Amount,Type,Discretion,Need_back,Return_Name,Return_Value,Able_flag)"); strSql.Append(" values ("); strSql.Append("@Product_Name,@Alias,@Amount,@Type,@Discretion,@Need_back,@Return_Name,@Return_Value,@Able_flag)"); MySqlParameter[] parameters = { new MySqlParameter("@Product_Name", MySqlDbType.VarChar,20), new MySqlParameter("@Alias", MySqlDbType.VarChar,20), new MySqlParameter("@Amount", MySqlDbType.Decimal,10), new MySqlParameter("@Type", MySqlDbType.Int32,11), new MySqlParameter("@Discretion", MySqlDbType.Text), new MySqlParameter("@Need_back", MySqlDbType.Int32,1), new MySqlParameter("@Return_Name", MySqlDbType.VarChar,20), new MySqlParameter("@Return_Value", MySqlDbType.Decimal,10), new MySqlParameter("@Able_flag", MySqlDbType.Int32,1)}; parameters[0].Value = model.Product_Name; parameters[1].Value = model.Alias; parameters[2].Value = model.Amount; parameters[3].Value = model.Type; parameters[4].Value = model.Discretion; parameters[5].Value = model.Need_back; parameters[6].Value = model.Return_Name; parameters[7].Value = model.Return_Value; parameters[8].Value = model.Able_flag; DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(Galant.Model.origin_paper_links model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into origin_paper_links("); strSql.Append("Paper_id,Origin_Name)"); strSql.Append(" values ("); strSql.Append("@Paper_id,@Origin_Name)"); MySqlParameter[] parameters = { new MySqlParameter("@Paper_id", MySqlDbType.VarChar,8), new MySqlParameter("@Origin_Name", MySqlDbType.VarChar,50)}; parameters[0].Value = model.Paper_id; parameters[1].Value = model.Origin_Name; DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(Galant.Model.paper_links model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into paper_links("); strSql.Append("Paper_id,Parent_id,Able_flag)"); strSql.Append(" values ("); strSql.Append("@Paper_id,@Parent_id,@Able_flag)"); MySqlParameter[] parameters = { new MySqlParameter("@Paper_id", MySqlDbType.VarChar,50), new MySqlParameter("@Parent_id", MySqlDbType.Int32,11), new MySqlParameter("@Able_flag", MySqlDbType.Int32,1)}; parameters[0].Value = model.Paper_id; parameters[1].Value = model.Parent_id; parameters[2].Value = model.Able_flag; DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(Galant.Model.routes model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into routes("); strSql.Append("Route_Name,from_entity,to_entity,Is_finally)"); strSql.Append(" values ("); strSql.Append("@Route_Name,@from_entity,@to_entity,@Is_finally)"); MySqlParameter[] parameters = { new MySqlParameter("@Route_Name", MySqlDbType.VarChar,32), new MySqlParameter("@from_entity", MySqlDbType.Int32,11), new MySqlParameter("@to_entity", MySqlDbType.Int32,11), new MySqlParameter("@Is_finally", MySqlDbType.Int32,1)}; parameters[0].Value = model.Route_Name; parameters[1].Value = model.from_entity; parameters[2].Value = model.to_entity; parameters[3].Value = model.Is_finally; DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(Galant.Model.stores model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into stores("); strSql.Append("Store_log,product_id,product_count,Bound)"); strSql.Append(" values ("); strSql.Append("@Store_log,@product_id,@product_count,@Bound)"); MySqlParameter[] parameters = { new MySqlParameter("@Store_log", MySqlDbType.Int32,11), new MySqlParameter("@product_id", MySqlDbType.Int32,11), new MySqlParameter("@product_count", MySqlDbType.Decimal,8), new MySqlParameter("@Bound", MySqlDbType.Int32,11)}; parameters[0].Value = model.Store_log; parameters[1].Value = model.product_id; parameters[2].Value = model.product_count; parameters[3].Value = model.Bound; DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(Galant.Model.packages model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into packages("); strSql.Append("Product_id,Count,Amount,Origin_Amount,Paper_id,State)"); strSql.Append(" values ("); strSql.Append("@Product_id,@Count,@Amount,@Origin_Amount,@Paper_id,@State)"); MySqlParameter[] parameters = { new MySqlParameter("@Product_id", MySqlDbType.Int32,11), new MySqlParameter("@Count", MySqlDbType.Decimal,8), new MySqlParameter("@Amount", MySqlDbType.Decimal,10), new MySqlParameter("@Origin_Amount", MySqlDbType.Decimal,10), new MySqlParameter("@Paper_id", MySqlDbType.VarChar,32), new MySqlParameter("@State", MySqlDbType.Int32,11)}; parameters[0].Value = model.Product_id; parameters[1].Value = model.Count; parameters[2].Value = model.Amount; parameters[3].Value = model.Origin_Amount; parameters[4].Value = model.Paper_id; parameters[5].Value = model.State; DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(Galant.Model.event_logs model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into event_logs("); strSql.Append("Paper_id,Insert_Time,Relation_Entity,At_Station,Event_Type,Event_Data)"); strSql.Append(" values ("); strSql.Append("@Paper_id,@Insert_Time,@Relation_Entity,@At_Station,@Event_Type,@Event_Data)"); MySqlParameter[] parameters = { new MySqlParameter("@Paper_id", MySqlDbType.VarChar,8), new MySqlParameter("@Insert_Time", MySqlDbType.DateTime), new MySqlParameter("@Relation_Entity", MySqlDbType.Int32,11), new MySqlParameter("@At_Station", MySqlDbType.Int32,11), new MySqlParameter("@Event_Type", MySqlDbType.VarChar,10), new MySqlParameter("@Event_Data", MySqlDbType.Text)}; parameters[0].Value = model.Paper_id; parameters[1].Value = model.Insert_Time; parameters[2].Value = model.Relation_Entity; parameters[3].Value = model.At_Station; parameters[4].Value = model.Event_Type; parameters[5].Value = model.Event_Data; DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public bool Update(Galant.Model.packages model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update packages set "); strSql.Append("Product_id=@Product_id,"); strSql.Append("Count=@Count,"); strSql.Append("Amount=@Amount,"); strSql.Append("Origin_Amount=@Origin_Amount,"); strSql.Append("Paper_id=@Paper_id,"); strSql.Append("State=@State"); strSql.Append(" where Package_id=@Package_id"); MySqlParameter[] parameters = { new MySqlParameter("@Package_id", MySqlDbType.Int32,11), new MySqlParameter("@Product_id", MySqlDbType.Int32,11), new MySqlParameter("@Count", MySqlDbType.Decimal,8), new MySqlParameter("@Amount", MySqlDbType.Decimal,10), new MySqlParameter("@Origin_Amount", MySqlDbType.Decimal,10), new MySqlParameter("@Paper_id", MySqlDbType.VarChar,32), new MySqlParameter("@State", MySqlDbType.Int32,11)}; parameters[0].Value = model.Package_id; parameters[1].Value = model.Product_id; parameters[2].Value = model.Count; parameters[3].Value = model.Amount; parameters[4].Value = model.Origin_Amount; parameters[5].Value = model.Paper_id; parameters[6].Value = model.State; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public bool Update(Galant.Model.paper_routes model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update paper_routes set "); strSql.Append("Paper_id=@Paper_id,"); strSql.Append("Route_id=@Route_id,"); strSql.Append("Is_Routed=@Is_Routed,"); strSql.Append("Able_flag=@Able_flag"); strSql.Append(" where Step_id=@Step_id"); MySqlParameter[] parameters = { new MySqlParameter("@Step_id", MySqlDbType.Int32,11), new MySqlParameter("@Paper_id", MySqlDbType.VarChar,8), new MySqlParameter("@Route_id", MySqlDbType.Int32,11), new MySqlParameter("@Is_Routed", MySqlDbType.Int32,1), new MySqlParameter("@Able_flag", MySqlDbType.Int32,1)}; parameters[0].Value = model.Step_id; parameters[1].Value = model.Paper_id; parameters[2].Value = model.Route_id; parameters[3].Value = model.Is_Routed; parameters[4].Value = model.Able_flag; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public bool Update(Galant.Model.routes model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update routes set "); strSql.Append("Route_Name=@Route_Name,"); strSql.Append("from_entity=@from_entity,"); strSql.Append("to_entity=@to_entity,"); strSql.Append("Is_finally=@Is_finally"); strSql.Append(" where Route_ID=@Route_ID"); MySqlParameter[] parameters = { new MySqlParameter("@Route_ID", MySqlDbType.Int32,11), new MySqlParameter("@Route_Name", MySqlDbType.VarChar,32), new MySqlParameter("@from_entity", MySqlDbType.Int32,11), new MySqlParameter("@to_entity", MySqlDbType.Int32,11), new MySqlParameter("@Is_finally", MySqlDbType.Int32,1)}; parameters[0].Value = model.Route_ID; parameters[1].Value = model.Route_Name; parameters[2].Value = model.from_entity; parameters[3].Value = model.to_entity; parameters[4].Value = model.Is_finally; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public bool Update(Galant.Model.paper_links model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update paper_links set "); strSql.Append("Paper_id=@Paper_id,"); strSql.Append("Parent_id=@Parent_id,"); strSql.Append("Able_flag=@Able_flag"); strSql.Append(" where Link_id=@Link_id"); MySqlParameter[] parameters = { new MySqlParameter("@Link_id", MySqlDbType.Int32,11), new MySqlParameter("@Paper_id", MySqlDbType.VarChar,50), new MySqlParameter("@Parent_id", MySqlDbType.Int32,11), new MySqlParameter("@Able_flag", MySqlDbType.Int32,1)}; parameters[0].Value = model.Link_id; parameters[1].Value = model.Paper_id; parameters[2].Value = model.Parent_id; parameters[3].Value = model.Able_flag; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public bool Update(Galant.Model.stores model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update stores set "); strSql.Append("Store_log=@Store_log,"); strSql.Append("product_id=@product_id,"); strSql.Append("product_count=@product_count,"); strSql.Append("Bound=@Bound"); strSql.Append(" where Store_id=@Store_id"); MySqlParameter[] parameters = { new MySqlParameter("@Store_id", MySqlDbType.Int32,11), new MySqlParameter("@Store_log", MySqlDbType.Int32,11), new MySqlParameter("@product_id", MySqlDbType.Int32,11), new MySqlParameter("@product_count", MySqlDbType.Decimal,8), new MySqlParameter("@Bound", MySqlDbType.Int32,11)}; parameters[0].Value = model.Store_id; parameters[1].Value = model.Store_log; parameters[2].Value = model.product_id; parameters[3].Value = model.product_count; parameters[4].Value = model.Bound; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public bool Update(Galant.Model.products model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update products set "); strSql.Append("Product_Name=@Product_Name,"); strSql.Append("Alias=@Alias,"); strSql.Append("Amount=@Amount,"); strSql.Append("Type=@Type,"); strSql.Append("Discretion=@Discretion,"); strSql.Append("Need_back=@Need_back,"); strSql.Append("Return_Name=@Return_Name,"); strSql.Append("Return_Value=@Return_Value,"); strSql.Append("Able_flag=@Able_flag"); strSql.Append(" where Product_id=@Product_id"); MySqlParameter[] parameters = { new MySqlParameter("@Product_id", MySqlDbType.Int32,11), new MySqlParameter("@Product_Name", MySqlDbType.VarChar,20), new MySqlParameter("@Alias", MySqlDbType.VarChar,20), new MySqlParameter("@Amount", MySqlDbType.Decimal,10), new MySqlParameter("@Type", MySqlDbType.Int32,11), new MySqlParameter("@Discretion", MySqlDbType.Text), new MySqlParameter("@Need_back", MySqlDbType.Int32,1), new MySqlParameter("@Return_Name", MySqlDbType.VarChar,20), new MySqlParameter("@Return_Value", MySqlDbType.Decimal,10), new MySqlParameter("@Able_flag", MySqlDbType.Int32,1)}; parameters[0].Value = model.Product_id; parameters[1].Value = model.Product_Name; parameters[2].Value = model.Alias; parameters[3].Value = model.Amount; parameters[4].Value = model.Type; parameters[5].Value = model.Discretion; parameters[6].Value = model.Need_back; parameters[7].Value = model.Return_Name; parameters[8].Value = model.Return_Value; parameters[9].Value = model.Able_flag; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public bool Update(Galant.Model.event_logs model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update event_logs set "); strSql.Append("Paper_id=@Paper_id,"); strSql.Append("Insert_Time=@Insert_Time,"); strSql.Append("Relation_Entity=@Relation_Entity,"); strSql.Append("At_Station=@At_Station,"); strSql.Append("Event_Type=@Event_Type,"); strSql.Append("Event_Data=@Event_Data"); strSql.Append(" where Event_id=@Event_id"); MySqlParameter[] parameters = { new MySqlParameter("@Event_id", MySqlDbType.Int32,11), new MySqlParameter("@Paper_id", MySqlDbType.VarChar,8), new MySqlParameter("@Insert_Time", MySqlDbType.DateTime), new MySqlParameter("@Relation_Entity", MySqlDbType.Int32,11), new MySqlParameter("@At_Station", MySqlDbType.Int32,11), new MySqlParameter("@Event_Type", MySqlDbType.VarChar,10), new MySqlParameter("@Event_Data", MySqlDbType.Text)}; parameters[0].Value = model.Event_id; parameters[1].Value = model.Paper_id; parameters[2].Value = model.Insert_Time; parameters[3].Value = model.Relation_Entity; parameters[4].Value = model.At_Station; parameters[5].Value = model.Event_Type; parameters[6].Value = model.Event_Data; int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }