/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Save(FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model m)
{
List <string> sqllist = new List <string>();
string[] arrCODE = m.CASUALTYDETAILCODE.Split(',');
string[] arrMONEY = m.CASUALTYDETAIMONEY.Split(',');
StringBuilder sbInsert = new StringBuilder();
sbInsert.AppendFormat("INSERT INTO FIRELOST_LOSTTYPE_CASUALTYDETAIL(FIRELOST_LOSTTYPE_CASUALTYID, CASUALTYDETAILCODE, CASUALTYDETAIMONEY)");
for (int i = 0; i < arrCODE.Length; i++)
{
#region 更新
if (isExists(new FIRELOST_LOSTTYPE_CASUALTYDETAIL_SW {
FIRELOST_LOSTTYPE_CASUALTYID = m.FIRELOST_LOSTTYPE_CASUALTYID, CASUALTYDETAILCODE = arrCODE[i]
}))
{
StringBuilder sbUpdate = new StringBuilder();
sbUpdate.AppendFormat("UPDATE FIRELOST_LOSTTYPE_CASUALTYDETAIL SET ");
sbUpdate.AppendFormat(" CASUALTYDETAIMONEY={0}", ClsSql.saveNullField(arrMONEY[i]));
sbUpdate.AppendFormat(" where FIRELOST_LOSTTYPE_CASUALTYID= '{0}'", ClsSql.EncodeSql(m.FIRELOST_LOSTTYPE_CASUALTYID));
sbUpdate.AppendFormat(" and CASUALTYDETAILCODE= '{0}'", ClsSql.EncodeSql(arrCODE[i]));
sqllist.Add(sbUpdate.ToString());
}
#endregion
#region 添加
else
{
sbInsert.AppendFormat(" select {0}", ClsSql.saveNullField(m.FIRELOST_LOSTTYPE_CASUALTYID));
sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrCODE[i]));;
sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrMONEY[i]));
sbInsert.AppendFormat(" UNION ALL ");
}
#endregion
}
string insertStr = sbInsert.ToString();
if (insertStr.Contains(" UNION ALL "))
{
insertStr = insertStr.Substring(0, insertStr.Length - 10);
sqllist.Add(insertStr);
}
var y = DataBaseClass.ExecuteSqlTran(sqllist);
if (y >= 0)
{
return(new Message(true, "保存成功!", ""));
}
else
{
return(new Message(false, "保存失败，事物回滚机制!", ""));
}
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model m)
{
if (m.opMethod == "Add" || m.opMethod == "Mdy")
{
Message msg = BaseDT.FIRELOST_LOSTTYPE_CASUALTYDETAIL.Save(m);
return(new Message(msg.Success, msg.Msg, msg.Url));
}
if (m.opMethod == "Del")
{
Message msg = BaseDT.FIRELOST_LOSTTYPE_CASUALTYDETAIL.Del(m);
return(new Message(msg.Success, msg.Msg, msg.Url));
}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model getModel(FIRELOST_LOSTTYPE_CASUALTYDETAIL_SW sw)
{
DataTable dt = BaseDT.FIRELOST_LOSTTYPE_CASUALTYDETAIL.getDT(sw);//列表
FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model m = new FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.CASUALTYDETAILID = dt.Rows[i]["CASUALTYDETAILID"].ToString();
m.FIRELOST_LOSTTYPE_CASUALTYID = dt.Rows[i]["FIRELOST_LOSTTYPE_CASUALTYID"].ToString();
m.CASUALTYDETAILCODE = dt.Rows[i]["CASUALTYDETAILCODE"].ToString();
m.CASUALTYDETAIMONEY = dt.Rows[i]["CASUALTYDETAIMONEY"].ToString();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model> getListModel(FIRELOST_LOSTTYPE_CASUALTYDETAIL_SW sw)
{
var result = new List <FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model>();
DataTable dt = BaseDT.FIRELOST_LOSTTYPE_CASUALTYDETAIL.getDT(sw);//列表
for (int i = 0; i < dt.Rows.Count; i++)
{
FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model m = new FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model();
m.CASUALTYDETAILID = dt.Rows[i]["CASUALTYDETAILID"].ToString();
m.FIRELOST_LOSTTYPE_CASUALTYID = dt.Rows[i]["FIRELOST_LOSTTYPE_CASUALTYID"].ToString();
m.CASUALTYDETAILCODE = dt.Rows[i]["CASUALTYDETAILCODE"].ToString();
m.CASUALTYDETAIMONEY = dt.Rows[i]["CASUALTYDETAIMONEY"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(FIRELOST_LOSTTYPE_CASUALTYDETAIL_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete FIRELOST_LOSTTYPE_CASUALTYDETAIL where 1=1");
if (!string.IsNullOrEmpty(m.CASUALTYDETAILID))
{
sb.AppendFormat(" and CASUALTYDETAILID= '{0}'", ClsSql.EncodeSql(m.CASUALTYDETAILID));
}
if (!string.IsNullOrEmpty(m.FIRELOST_LOSTTYPE_CASUALTYID))
{
sb.AppendFormat(" and FIRELOST_LOSTTYPE_CASUALTYID= '{0}'", ClsSql.EncodeSql(m.FIRELOST_LOSTTYPE_CASUALTYID));
}
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功!", ""));
}
else
{
return(new Message(false, "删除失败!", ""));
}
}
