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