public bool Update(PrintALLModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" UPDATE SYS_PRINT_ALL SET ");
builder.Append("PrintID=@PrintID,");
builder.Append("FileButtonName=@FileButtonName,");
builder.Append("IsDouble=@IsDouble,");
builder.Append("PrintOrders=@PrintOrders,");
builder.Append("Col2=@Col2,");
builder.Append("Col3=@Col3");
builder.Append(" WHERE ID=@ID");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@PrintID", MySqlDbType.Int32),
new MySqlParameter("@FileButtonName", MySqlDbType.String),
new MySqlParameter("@IsDouble", MySqlDbType.String),
new MySqlParameter("@PrintOrders", MySqlDbType.Int32),
new MySqlParameter("@Col2", MySqlDbType.String),
new MySqlParameter("@Col3", MySqlDbType.String),
new MySqlParameter("ID", MySqlDbType.Int32)
};
cmdParms[0].Value = model.PrintID;
cmdParms[1].Value = model.FileButtonName;
cmdParms[2].Value = model.IsDouble;
cmdParms[3].Value = model.PrintOrders;
cmdParms[4].Value = model.Col2;
cmdParms[5].Value = model.Col3;
cmdParms[6].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public int Add(PrintALLModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" INSERT INTO SYS_PRINT_ALL(");
builder.Append("PrintID,FileButtonName,IsDouble,PrintOrders,Col2,Col3)");
builder.Append(" VALUES (");
builder.Append("@PrintID,@FileButtonName,@IsDouble,@PrintOrders,@Col2,@Col3)");
builder.Append(";SELECT @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@PrintID", MySqlDbType.Int32),
new MySqlParameter("@FileButtonName", MySqlDbType.String),
new MySqlParameter("@IsDouble", MySqlDbType.String),
new MySqlParameter("@PrintOrders", MySqlDbType.Int32),
new MySqlParameter("@Col2", MySqlDbType.String),
new MySqlParameter("@Col3", MySqlDbType.String)
};
cmdParms[0].Value = model.PrintID;
cmdParms[1].Value = model.FileButtonName;
cmdParms[2].Value = model.IsDouble;
cmdParms[3].Value = model.PrintOrders;
cmdParms[4].Value = model.Col2;
cmdParms[5].Value = model.Col3;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public bool Update(PrintALLModel model)
{
return(dal.Update(model));
}
public int Add(PrintALLModel model)
{
return(dal.Add(model));
}
