/// <summary>
/// 保存
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Save(FIRELOST_LOSTTYPECOUNT_Model m)
{
List <string> sqllist = new List <string>();
string[] arrCode = m.FIRELOSETYPECODE.Split(',');
string[] arrMonery = m.LOSEMONEY.Split(',');
string[] arrMark = m.MARK.Split(',');
StringBuilder sbInsert = new StringBuilder();
sbInsert.AppendFormat("Insert into FIRELOST_LOSTTYPECOUNT(FIRELOST_FIREINFOID, FIRELOSETYPECODE, LOSEMONEY, MARK)");
for (int i = 0; i < arrCode.Length; i++)
{
#region 更新
if (isExists(new FIRELOST_LOSTTYPECOUNT_SW {
FIRELOST_FIREINFOID = m.FIRELOST_FIREINFOID, FIRELOSETYPECODE = arrCode[i]
}))
{
StringBuilder sbUpdate = new StringBuilder();
sbUpdate.AppendFormat("UPDATE FIRELOST_LOSTTYPECOUNT SET ");
sbUpdate.AppendFormat(" LOSEMONEY={0}", ClsSql.saveNullField(arrMonery[i]));
sbUpdate.AppendFormat(",MARK={0}", ClsSql.saveNullField(arrMark[i]));
sbUpdate.AppendFormat(" where FIRELOST_FIREINFOID= '{0}'", ClsSql.EncodeSql(m.FIRELOST_FIREINFOID));
sbUpdate.AppendFormat(" and FIRELOSETYPECODE= '{0}'", ClsSql.EncodeSql(arrCode[i]));
sqllist.Add(sbUpdate.ToString());
}
#endregion
#region 添加
else
{
sbInsert.AppendFormat(" select {0}", ClsSql.saveNullField(m.FIRELOST_FIREINFOID));
sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrCode[i]));;
sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrMonery[i]));
sbInsert.AppendFormat(",{0}", ClsSql.saveNullField(arrMark[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 Del(FIRELOST_LOSTTYPECOUNT_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete FIRELOST_LOSTTYPECOUNT");
sb.AppendFormat(" where FIRELOST_LOSTTYPECOUNTID= '{0}'", ClsSql.EncodeSql(m.FIRELOST_LOSTTYPECOUNTID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功!", ""));
}
else
{
return(new Message(false, "删除失败!", ""));
}
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static FIRELOST_LOSTTYPECOUNT_Model getModel(FIRELOST_LOSTTYPECOUNT_SW sw)
{
DataTable dt = BaseDT.FIRELOST_LOSTTYPECOUNT.getDT(sw);//列表
FIRELOST_LOSTTYPECOUNT_Model m = new FIRELOST_LOSTTYPECOUNT_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.FIRELOST_LOSTTYPECOUNTID = dt.Rows[i]["FIRELOST_LOSTTYPECOUNTID"].ToString();
m.FIRELOST_FIREINFOID = dt.Rows[i]["FIRELOST_FIREINFOID"].ToString();
m.FIRELOSETYPECODE = dt.Rows[i]["FIRELOSETYPECODE"].ToString();
m.LOSEMONEY = dt.Rows[i]["LOSEMONEY"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <FIRELOST_LOSTTYPECOUNT_Model> getListModel(FIRELOST_LOSTTYPECOUNT_SW sw)
{
var result = new List <FIRELOST_LOSTTYPECOUNT_Model>();
DataTable dt = BaseDT.FIRELOST_LOSTTYPECOUNT.getDT(sw);//列表
for (int i = 0; i < dt.Rows.Count; i++)
{
FIRELOST_LOSTTYPECOUNT_Model m = new FIRELOST_LOSTTYPECOUNT_Model();
m.FIRELOST_LOSTTYPECOUNTID = dt.Rows[i]["FIRELOST_LOSTTYPECOUNTID"].ToString();
m.FIRELOST_FIREINFOID = dt.Rows[i]["FIRELOST_FIREINFOID"].ToString();
m.FIRELOSETYPECODE = dt.Rows[i]["FIRELOSETYPECODE"].ToString();
m.LOSEMONEY = dt.Rows[i]["LOSEMONEY"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(FIRELOST_LOSTTYPECOUNT_Model m)
{
Message msg = BaseDT.FIRELOST_LOSTTYPECOUNT.Save(m);
return(new Message(msg.Success, msg.Msg, msg.Url));
}
