/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(XHD.Model.scm_authority_dtcolumn model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into scm_authority_dtcolumn(");
strSql.Append("factory_Id,suppliers_id,Menu_ids,column_ids,Create_id,Create_date)");
strSql.Append(" values (");
strSql.Append("@factory_Id,@suppliers_id,@Menu_ids,@column_ids,@Create_id,@Create_date)");
MySqlParameter[] parameters =
{
new MySqlParameter("@factory_Id", MySqlDbType.VarChar, 60),
new MySqlParameter("@suppliers_id", MySqlDbType.Int16, 5),
new MySqlParameter("@Menu_ids", MySqlDbType.VarChar, 1000),
new MySqlParameter("@column_ids", MySqlDbType.VarChar, 1000),
new MySqlParameter("@Create_id", MySqlDbType.Int32, 11),
new MySqlParameter("@Create_date", MySqlDbType.DateTime)
};
parameters[0].Value = model.factory_Id;
parameters[1].Value = model.suppliers_id;
parameters[2].Value = model.Menu_ids;
parameters[3].Value = model.column_ids;
parameters[4].Value = model.Create_id;
parameters[5].Value = model.Create_date;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.scm_authority_dtcolumn GetModel(string factory_Id, int suppliers_id, string Menu_ids, string column_ids, int Create_id, DateTime Create_date)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select factory_Id,suppliers_id,Menu_ids,column_ids,Create_id,Create_date from scm_authority_dtcolumn ");
strSql.Append(" where factory_Id=@factory_Id and suppliers_id=@suppliers_id and Menu_ids=@Menu_ids and column_ids=@column_ids and Create_id=@Create_id and Create_date=@Create_date ");
MySqlParameter[] parameters =
{
new MySqlParameter("@factory_Id", MySqlDbType.VarChar, 60),
new MySqlParameter("@suppliers_id", MySqlDbType.Int16, 5),
new MySqlParameter("@Menu_ids", MySqlDbType.VarChar, 1000),
new MySqlParameter("@column_ids", MySqlDbType.VarChar, 1000),
new MySqlParameter("@Create_id", MySqlDbType.Int32, 11),
new MySqlParameter("@Create_date", MySqlDbType.DateTime)
};
parameters[0].Value = factory_Id;
parameters[1].Value = suppliers_id;
parameters[2].Value = Menu_ids;
parameters[3].Value = column_ids;
parameters[4].Value = Create_id;
parameters[5].Value = Create_date;
XHD.Model.scm_authority_dtcolumn model = new XHD.Model.scm_authority_dtcolumn();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.scm_authority_dtcolumn DataRowToModel(DataRow row)
{
XHD.Model.scm_authority_dtcolumn model = new XHD.Model.scm_authority_dtcolumn();
if (row != null)
{
if (row["factory_Id"] != null)
{
model.factory_Id = row["factory_Id"].ToString();
}
if (row["suppliers_id"] != null && row["suppliers_id"].ToString() != "")
{
model.suppliers_id = int.Parse(row["suppliers_id"].ToString());
}
if (row["Menu_ids"] != null)
{
model.Menu_ids = row["Menu_ids"].ToString();
}
if (row["column_ids"] != null)
{
model.column_ids = row["column_ids"].ToString();
}
if (row["Create_id"] != null && row["Create_id"].ToString() != "")
{
model.Create_id = int.Parse(row["Create_id"].ToString());
}
if (row["Create_date"] != null && row["Create_date"].ToString() != "")
{
model.Create_date = DateTime.Parse(row["Create_date"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XHD.Model.scm_authority_dtcolumn model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update scm_authority_dtcolumn set ");
strSql.Append("factory_Id=@factory_Id,");
strSql.Append("suppliers_id=@suppliers_id,");
strSql.Append("Menu_ids=@Menu_ids,");
strSql.Append("column_ids=@column_ids,");
strSql.Append("Create_id=@Create_id,");
strSql.Append("Create_date=@Create_date");
strSql.Append(" where factory_Id=@factory_Id and suppliers_id=@suppliers_id and Menu_ids=@Menu_ids and column_ids=@column_ids and Create_id=@Create_id and Create_date=@Create_date ");
MySqlParameter[] parameters =
{
new MySqlParameter("@factory_Id", MySqlDbType.VarChar, 60),
new MySqlParameter("@suppliers_id", MySqlDbType.Int16, 5),
new MySqlParameter("@Menu_ids", MySqlDbType.VarChar, 1000),
new MySqlParameter("@column_ids", MySqlDbType.VarChar, 1000),
new MySqlParameter("@Create_id", MySqlDbType.Int32, 11),
new MySqlParameter("@Create_date", MySqlDbType.DateTime)
};
parameters[0].Value = model.factory_Id;
parameters[1].Value = model.suppliers_id;
parameters[2].Value = model.Menu_ids;
parameters[3].Value = model.column_ids;
parameters[4].Value = model.Create_id;
parameters[5].Value = model.Create_date;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Adds(XHD.Model.scm_authority_dtcolumn model)
{
List <string> strSqlList = new List <string>();
string[] menu_ids = model.Menu_ids.Split(',');
string[] column_ids;
string strSql = string.Empty;
string ids = model.column_ids.Replace(",", "");
if (!string.IsNullOrEmpty(ids))
{
foreach (var item in menu_ids)
{
if (!string.IsNullOrEmpty(item))
{
//查询该页面下的列
DataSet ds = GetListColumn("Menu_id='" + item + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string columnIds = model.column_ids.Substring(2, model.column_ids.Length - 3);
if (columnIds.Length > 2)
{
string s = string.Empty;
column_ids = columnIds.Split(',');
foreach (var items in column_ids)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int column_id = Convert.ToInt32(ds.Tables[0].Rows[i]["column_id"].ToString());
if (column_id == Convert.ToInt32(items))
{
s += items + ",";
break;
}
}
}
strSql = string.Format(@"insert into scm_authority_dtcolumn (factory_Id,suppliers_id,Menu_ids,column_ids,Create_id,Create_date)
values('{0}','{1}','{2}','{3}','{4}','{5}')", model.factory_Id, model.suppliers_id, item, s, model.Create_id, model.Create_date);
strSqlList.Add(strSql);
}
else
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int column_id = Convert.ToInt32(ds.Tables[0].Rows[i]["column_id"].ToString());
if (column_id == Convert.ToInt32(columnIds))
{
strSql = string.Format(@"insert into scm_authority_dtcolumn (factory_Id,suppliers_id,Menu_ids,column_ids,Create_id,Create_date)
values('{0}','{1}','{2}','{3}','{4}','{5}')", model.factory_Id, model.suppliers_id, item, columnIds, model.Create_id, model.Create_date);
strSqlList.Add(strSql);
}
}
}
}
}
}
}
int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
