/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <param name="list"></param>
/// <returns></returns>
public static bool SaveData(UnitGroupModel model, IList <UnitGroupDetailModel> list)
{
ArrayList sqlList = new ArrayList();
if (!model.ID.HasValue)
{// 新增
sqlList.Add(UnitGroupDBHelper.InsertCommand(model));
}
else
{// 修改
sqlList.Add(UnitGroupDBHelper.UpdateCommand(model));
sqlList.Add(UnitGroupDetailDBHelper.DeleteCommand(model.CompanyCD, model.GroupUnitNo));
}
foreach (UnitGroupDetailModel info in list)
{
sqlList.Add(UnitGroupDetailDBHelper.InsertCommand(info));
}
if (SqlHelper.ExecuteTransWithArrayList(sqlList))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="iD"></param>
/// <param name="CompanyCD"></param>
/// <param name="GroupUnitNo"></param>
/// <returns></returns>
public static bool DeleteData(int[] iD, string CompanyCD, string[] GroupUnitNo)
{
ArrayList sqlList = new ArrayList();
for (int i = 0; i < iD.Length; i++)
{
sqlList.Add(UnitGroupDBHelper.DeleteCommand(iD[i]));
if (i < GroupUnitNo.Length)
{
sqlList.Add(UnitGroupDetailDBHelper.DeleteCommand(CompanyCD, GroupUnitNo[i]));
}
}
if (SqlHelper.ExecuteTransWithArrayList(sqlList))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 查询数据记录
/// </summary>
/// <param name="companyCD">企业代码</param>
/// <param name="groupUnitNo">计量单位组编号</param>
/// <returns>返回DataSet数据集</returns>
public static DataTable SelectDataTable(string companyCD, string groupUnitNo)
{
return(UnitGroupDetailDBHelper.SelectDataTable(companyCD, groupUnitNo));
}
/// <summary>
/// 查询数据记录
/// </summary>
/// <param name="iD"></param>
/// <returns>返回DataSet数据集</returns>
public static DataTable SelectDataTable(int iD)
{
return(UnitGroupDetailDBHelper.SelectDataTable(iD));
}
