/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(T_SYS_ORGModel m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE T_SYS_ORG");
sb.AppendFormat(" set ");
sb.AppendFormat("ORGNO='{0}'", ClsSql.EncodeSql(m.ORGNO));
sb.AppendFormat(",ORGNAME='{0}'", ClsSql.EncodeSql(m.ORGNAME));
sb.AppendFormat(",ORGDUTY='{0}'", ClsSql.EncodeSql(m.ORGDUTY));
sb.AppendFormat(",LEADER='{0}'", ClsSql.EncodeSql(m.LEADER));
sb.AppendFormat(",AREACODE='{0}'", ClsSql.EncodeSql(m.AREACODE));
sb.AppendFormat(",SYSFLAG='{0}'", ClsSql.EncodeSql(m.SYSFLAG));
sb.AppendFormat(",ORGJC='{0}'", ClsSql.EncodeSql(m.ORGJC));
sb.AppendFormat(",JD={0}", ClsSql.saveNullField(m.JD));
sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD));
sb.AppendFormat(",COMMANDNAME={0}", ClsSql.saveNullField(m.COMMANDNAME));
sb.AppendFormat(",WEATHERJC={0}", ClsSql.saveNullField(m.WEATHERJC));
sb.AppendFormat(",POSTCODE={0}", ClsSql.saveNullField(m.POSTCODE));
sb.AppendFormat(",DUTYTELL={0}", ClsSql.saveNullField(m.DUTYTELL));
sb.AppendFormat(",FAX={0}", ClsSql.saveNullField(m.FAX));
sb.AppendFormat(",WXJC={0}", ClsSql.saveNullField(m.WXJC));
sb.AppendFormat(",ADDRESS={0}", ClsSql.saveNullField(m.ADDRESS));
sb.AppendFormat(" where ORGNO='{0}'", ClsSql.EncodeSql(m.ORGNO));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功！", m.returnUrl));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确！", m.returnUrl));
}
}
/// <summary>
/// 获取上级的tree
/// </summary>
/// <param name="dtCar"></param>
/// <param name="Org"></param>
/// <returns></returns>
private static JObject getJobejctCar(DataTable dtCar, T_SYS_ORGModel Org)
{
JObject root = new JObject {
{ "id", Org.ORGNO }, { "text", Org.ORGNAME + GetCarCount(dtCar, Org.ORGNO) }, { "state", "closed" }
};
return(root);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(T_SYS_ORGModel m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete T_SYS_ORG");
sb.AppendFormat(" where ORGNO= '{0}'", ClsSql.EncodeSql(m.ORGNO));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功！", m.returnUrl));
}
else
{
return(new Message(false, "删除失败，请检查各输入框是否正确！", m.returnUrl));
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(T_SYS_ORGModel m)
{
if (isExists(new T_SYS_ORGSW {
ORGNO = m.ORGNO,
}) == true)
{
return(new Message(false, "添加失败，该组织机构码已存在！", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO T_SYS_ORG(ORGNO, ORGNAME, ORGDUTY, LEADER, AREACODE, SYSFLAG,ORGJC,JD, WD,COMMANDNAME,WEATHERJC,POSTCODE,DUTYTELL,FAX,WXJC,ADDRESS )");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.ORGNO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORGNAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORGDUTY));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.LEADER));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.AREACODE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SYSFLAG));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORGJC));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.COMMANDNAME));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WEATHERJC));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.POSTCODE));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.DUTYTELL));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FAX));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WXJC));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ADDRESS));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功！", m.returnUrl));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确！", m.returnUrl));
}
}
/// <summary>
/// 修改护林员参数
/// </summary>
/// <param name="m">对象</param>
/// <returns></returns>
public static Message update(T_SYS_ORGModel m)
{
StringBuilder sb = new StringBuilder();
var orgNo = m.ORGNO;
sb.AppendFormat("UPDATE T_SYS_ORG");
sb.AppendFormat(" set ");
sb.AppendFormat("MOBILEPARAMLIST='{0}'", ClsSql.EncodeSql(m.MOBILEPARAMLIST));
if (orgNo.Substring(4, 11) == "00000000000")//获取所有市的
{
var str = orgNo.Substring(0, 4) + "%";
sb.AppendFormat(" where ORGNO LIKE '{0}'", str);
}
else if (orgNo.Substring(6, 9) == "000000000")//获取所有县的
{
var str = orgNo.Substring(0, 6) + "%";
sb.AppendFormat(" where ORGNO LIKE '{0}'", str);
}
else if (orgNo.Substring(9, 6) == "0000000")//获取所有乡镇的
{
var str = orgNo.Substring(0, 9) + "%";
sb.AppendFormat(" where ORGNO LIKE '{0}'", str);
}
else
{
sb.AppendFormat(" where ORGNO='{0}'", ClsSql.EncodeSql(m.ORGNO));
}
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功！", m.returnUrl));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确！", m.returnUrl));
}
}
