/// <summary>
/// 添加
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Add(DC_REPOSITORY_Model m)
{
if (DC_ARMY.isExistsPoint(new DC_ARMY_Model {
JD = m.JD, WD = m.WD
}) == false)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO DC_REPOSITORY( NAME,ADDRESS,BYORGNO,RESPONSIBLEMAN,LINKWAY,REPTYPEID,JD,WD ) output inserted.DCREPOSITORYID");
sb.AppendFormat(" VALUES(");
sb.AppendFormat("{0},", ClsSql.saveNullField(m.NAME));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.ADDRESS));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.BYORGNO));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.RESPONSIBLEMAN));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.LINKWAY));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.REPTYPEID));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.JD));
sb.AppendFormat("{0}", ClsSql.saveNullField(m.WD));
sb.AppendFormat(")");
try
{
string strid = DataBaseClass.ReturnSqlField(sb.ToString());
return(new Message(true, "添加成功！", strid));
}
catch (Exception)
{
throw;
}
}
else
{
return(new Message(false, "添加失败,已有相同的位置的仓库！", ""));
}
}
/// <summary>
/// 添加返回当前记录的id
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Add(DC_ARMY_Model m)
{
if (DC_ARMY.isExistsPoint(new DC_ARMY_Model { JD = m.JD, WD = m.WD }) == false)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO DC_ARMY( ARMYTYPE, NUMBER, NAME, BYORGNO, ARMYMEMBERCOUNT, ARMYLEADER, CONTACTS,ARMYCHARACTER, ARMYEQUIP, MARK, JD, WD) output inserted.DC_ARMY_ID");
sb.AppendFormat(" VALUES(");
sb.AppendFormat("{0}", ClsSql.saveNullField(m.ARMYTYPE));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.NUMBER));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.NAME));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BYORGNO));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ARMYMEMBERCOUNT));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ARMYLEADER));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.CONTACTS));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ARMYCHARACTER));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ARMYEQUIP));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MARK));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD));
sb.AppendFormat(")");
try
{
string strid = DataBaseClass.ReturnSqlField(sb.ToString());
if (string.IsNullOrEmpty(strid)==false)
{
return new Message(true, "添加成功！", strid);
}
else
{
return new Message(false, "添加失败！请检查输入框是否正确！", strid);
}
}
catch (Exception)
{
throw;
}
}
else
{
return new Message(false, "添加失败,已有相同的位置的队伍！", "");
}
}
