public frmBox(DB_Talk.Model.m_Box model, int operate)
{
InitializeComponent();
_operate = operate;
if (operate == 0)
{
_mModelOld = null;
this.FormTitle = "添加";
btnOK.Text = "添加";
this.txtIP.Text = "172.21.0.2";
//this.txtNetIP.Text= "10.21.0.2";
//this.txtMask.Text = "255.255.255.0";
this.txtNetIP.Enabled=false;
this.txtMask.Enabled = false;
this.txtDispatchIP1.Text = "172.21.0.41";
this.txtDispatchIP2.Text = "172.21.0.42";
this.txtRecordServerIP.Text = "172.21.0.21";
this.txtTimerIP.Text = "";
}
else
{
btnTest.Visible = false;
_mModel = model;
_mModelOld = (DB_Talk.Model.m_Box)model.Clone();
this.FormTitle = "编辑";
btnOK.Text = "编辑";
ShowModel();
}
//this.txtName.MaxLength = Global.Params.NameLen;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DB_Talk.Model.m_StaticRoute model,bool IsReturnID)
{
int Result=0;
StringBuilder strSql=new StringBuilder();
StringBuilder strSql1=new StringBuilder();
StringBuilder strSql2=new StringBuilder();
if(model.BoxID!=null)
{
strSql1.Append("BoxID,");
strSql2.Append("'"+ model.BoxID +"',");
}
if(model.vc_NetIP!=null)
{
strSql1.Append("vc_NetIP,");
strSql2.Append("'"+ model.vc_NetIP +"',");
}
if(model.vc_Mask!=null)
{
strSql1.Append("vc_Mask,");
strSql2.Append("'"+ model.vc_Mask +"',");
}
if(model.vc_GateWayIP!=null)
{
strSql1.Append("vc_GateWayIP,");
strSql2.Append("'"+ model.vc_GateWayIP +"',");
}
if(model.vc_Memo!=null)
{
strSql1.Append("vc_Memo,");
strSql2.Append("'"+ model.vc_Memo +"',");
}
if(model.i_Flag!=null)
{
strSql1.Append("i_Flag,");
strSql2.Append("'"+ model.i_Flag +"',");
}
strSql.Append("insert into m_StaticRoute(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
if (IsReturnID)
{
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
Result = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
else
Result=-1;
}
else
{
Result = ExecuteSql(strSql.ToString());
}
return Result;
}
//删除路由组
private static bool DeleteRouteGroup(DB_Talk.Model.m_RouteGroup model)
{
bool b = false;
if (!IsBoxExitRouteGroup(model)) return true;
if (model.ID > 0 && model.vc_Name != "")
{
b = MBoxSDK.ConfigSDK.MBOX_DeleteRouteGroup(Global.Params.BoxHandle, (uint)model.ID, model.vc_Name);
}
return b;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DB_Talk.Model.m_RegionRelation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update m_RegionRelation set ");
if (model.BoxID != null)
{
strSql.Append("BoxID=" + model.BoxID + ",");
}
else
{
strSql.Append("BoxID= null ,");
}
if (model.RegionID != null)
{
strSql.Append("RegionID='" + model.RegionID + "',");
}
else
{
strSql.Append("RegionID= null ,");
}
if (model.i_RelationType != null)
{
strSql.Append("i_RelationType=" + model.i_RelationType + ",");
}
else
{
strSql.Append("i_RelationType= null ,");
}
if (model.RelationID != null)
{
strSql.Append("RelationID=" + model.RelationID + ",");
}
else
{
strSql.Append("RelationID= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where ID=" + model.ID + "");
int rowsAffected = DB.OleDbHelper.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return true;
}
else
{
return false;
}
}
//创建路由组
private static bool CreateRouteGroup(DB_Talk.Model.m_RouteGroup model,out int RouteGroupID)
{
//创建路由组只传入名称，没有ID
bool b = false;
RouteGroupID = 0;
List<DB_Talk.Model.m_RouteGroup> lst = new List<DB_Talk.Model.m_RouteGroup>();
QueryRouteGroup(out lst);
if (lst != null && lst.Count > 0)
{
DB_Talk.Model.m_RouteGroup temp = lst.Find(item => item.vc_Name == model.vc_Name);
if (temp != null) //存在相同名称的,直接返回相同名称的路由组ID
{
RouteGroupID = temp.ID;
return true; //存在的不再添加
}
else
{
model.ID = lst[lst.Count - 1].ID +1; //不存在相同名称的，需要新建，ID为目前最大ID+1
}
}
else
{
model.ID = 1; //没有路由的情况下ID从1开始
}
if (model.ID > 0 && model.vc_Name != "")
{
RouteGroupID = model.ID;
b = MBoxSDK.ConfigSDK.MBOX_CreateRouteGroup(Global.Params.BoxHandle, (uint)model.ID, model.vc_Name);
}
return b;
/*
bool b = false;
List<DB_Talk.Model.m_RouteGroup> lst = new List<DB_Talk.Model.m_RouteGroup>();
QueryRouteGroup(out lst);
if (lst != null && lst.Count > 0)
{
if (lst.Contains(model))
{
return true; //存在的不再添加
}
}
if (model.ID > 0 && model.vc_Name != "")
{
b = MBoxSDK.ConfigSDK.MBOX_CreateRouteGroup(Global.Params.BoxHandle, (uint)model.ID, model.vc_Name);
}
return b;
*/
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DB_Talk.Model.m_CameraInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update m_CameraInfo set ");
if (model.BoxID != null)
{
strSql.Append("BoxID="+model.BoxID+",");
}
else
{
strSql.Append("BoxID= null ,");
}
if (model.vc_Name != null)
{
strSql.Append("vc_Name='"+model.vc_Name+"',");
}
else
{
strSql.Append("vc_Name= null ,");
}
if (model.vc_Memo != null)
{
strSql.Append("vc_Memo='"+model.vc_Memo+"',");
}
else
{
strSql.Append("vc_Memo= null ,");
}
if (model.i_ChanelID != null)
{
strSql.Append("i_ChanelID="+model.i_ChanelID+",");
}
else
{
strSql.Append("i_ChanelID= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where ID="+ model.ID+"");
int rowsAffected=DB.OleDbHelper.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DB_Talk.Model.Data_MemberState model,bool IsReturnID)
{
int Result=0;
StringBuilder strSql=new StringBuilder();
StringBuilder strSql1=new StringBuilder();
StringBuilder strSql2=new StringBuilder();
if(model.i_DispatchNumber!=null)
{
strSql1.Append("i_DispatchNumber,");
strSql2.Append("'"+ model.i_DispatchNumber +"',");
}
if(model.i_Number!=null)
{
strSql1.Append("i_Number,");
strSql2.Append("'"+ model.i_Number +"',");
}
if(model.i_PeerNumber!=null)
{
strSql1.Append("i_PeerNumber,");
strSql2.Append("'"+ model.i_PeerNumber +"',");
}
if(model.i_State!=null)
{
strSql1.Append("i_State,");
strSql2.Append("'"+ model.i_State +"',");
}
strSql.Append("insert into Data_MemberState(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
if (IsReturnID)
{
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
Result = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
else
Result=-1;
}
else
{
Result = ExecuteSql(strSql.ToString());
}
return Result;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DB_Talk.Model.m_GroupMembers model,bool IsReturnID)
{
int Result=0;
StringBuilder strSql=new StringBuilder();
StringBuilder strSql1=new StringBuilder();
StringBuilder strSql2=new StringBuilder();
if(model.BoxID!=null)
{
strSql1.Append("BoxID,");
strSql2.Append("'"+ model.BoxID +"',");
}
if(model.GroupID!=null)
{
strSql1.Append("GroupID,");
strSql2.Append("'"+ model.GroupID +"',");
}
if(model.MemberID!=null)
{
strSql1.Append("MemberID,");
strSql2.Append("'"+ model.MemberID +"',");
}
strSql.Append("insert into m_GroupMembers(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
if (IsReturnID)
{
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
Result = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
else
Result=-1;
}
else
{
Result = ExecuteSql(strSql.ToString());
}
return Result;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DB_Talk.Model.m_CameraInfo model)
{
StringBuilder strSql=new StringBuilder();
StringBuilder strSql1=new StringBuilder();
StringBuilder strSql2=new StringBuilder();
if (model.BoxID != null)
{
strSql1.Append("BoxID,");
strSql2.Append(""+model.BoxID+",");
}
if (model.vc_Name != null)
{
strSql1.Append("vc_Name,");
strSql2.Append("'"+model.vc_Name+"',");
}
if (model.vc_Memo != null)
{
strSql1.Append("vc_Memo,");
strSql2.Append("'"+model.vc_Memo+"',");
}
if (model.i_ChanelID != null)
{
strSql1.Append("i_ChanelID,");
strSql2.Append(""+model.i_ChanelID+",");
}
strSql.Append("insert into m_CameraInfo(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DB.OleDbHelper.ExecuteSql(strSql.ToString());
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DB_Talk.Model.m_RegionRelation model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.BoxID != null)
{
strSql1.Append("BoxID,");
strSql2.Append("" + model.BoxID + ",");
}
if (model.RegionID != null)
{
strSql1.Append("RegionID,");
strSql2.Append("'" + model.RegionID + "',");
}
if (model.i_RelationType != null)
{
strSql1.Append("i_RelationType,");
strSql2.Append("" + model.i_RelationType + ",");
}
if (model.RelationID != null)
{
strSql1.Append("RelationID,");
strSql2.Append("" + model.RelationID + ",");
}
strSql.Append("insert into m_RegionRelation(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DB.OleDbHelper.ExecuteSql(strSql.ToString());
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public frmDepartment(DB_Talk.Model.m_Departments model, int operate)
{
InitializeComponent();
if (Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh != 0)
this.txtName.MaxLength = Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh;// Global.Params.NameLen;
if (operate == 0)
{
this.FormTitle = "添加";
btnOK.Text = "添加";
}
else
{
_mModel = model;
this.FormTitle = "编辑";
btnOK.Text = "编辑";
ShowModel();
}
}
public frmCalledRule(DB_Talk.Model.m_CalledRule m, int operate)
{
InitializeComponent();
_operate = operate;
if (operate == 0)
{
this.FormTitle = "添加";
btnOK.Text = "添加";
}
else
{
_mModel = m;
this.FormTitle = "编辑";
btnOK.Text = "编辑";
// ShowModel();
}
this.Load += new EventHandler(frmCalledRule_Load);
}
public frmGroup(DB_Talk.Model.m_Group model, int operate)
{
InitializeComponent();
_mModel = model;
if (_mModel.GroupTypeID == CommControl.PublicEnums.EnumGroupType.Normal.GetHashCode())
GroupType = "调度";
else if((_mModel.GroupTypeID == CommControl.PublicEnums.EnumGroupType.Meeting.GetHashCode()))
GroupType = "会议";
if (operate == 0)
{
this.FormTitle = "添加";
btnOK.Text = "添加";
}
else
{
this.FormTitle = "编辑";
btnOK.Text = "编辑";
ShowModel();
}
if (Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh != 0)
this.txtName.MaxLength = Global.Params.ConfigModel.SystemConfig.MaxNameTextLengh;// Global.Params.NameLen;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DB_Talk.Model.m_CalinglSourceRule model,bool IsReturnID)
{
int Result=0;
StringBuilder strSql=new StringBuilder();
StringBuilder strSql1=new StringBuilder();
StringBuilder strSql2=new StringBuilder();
//if (model.ID != null)
//{
// strSql1.Append("ID,");
// strSql2.Append("'" + model.ID + "',");
//}
if(model.BoxID>0)
{
strSql1.Append("BoxID,");
strSql2.Append("'"+ model.BoxID +"',");
}
if(model.vc_Code!=null)
{
strSql1.Append("vc_Code,");
strSql2.Append("'"+ model.vc_Code +"',");
}
if(model.vc_Name!=null)
{
strSql1.Append("vc_Name,");
strSql2.Append("'"+ model.vc_Name +"',");
}
if(model.CallingOrigID!=null)
{
strSql1.Append("CallingOrigID,");
strSql2.Append("'"+ model.CallingOrigID +"',");
}
if(model.i_ServerType!=null)
{
strSql1.Append("i_ServerType,");
strSql2.Append("'"+ model.i_ServerType +"',");
}
if(model.i_MinReLength!=null)
{
strSql1.Append("i_MinReLength,");
strSql2.Append("'"+ model.i_MinReLength +"',");
}
if(model.OriRouteID!=null)
{
strSql1.Append("OriRouteID,");
strSql2.Append("'"+ model.OriRouteID +"',");
}
if(model.CalledRuleID!=null)
{
strSql1.Append("CalledRuleID,");
strSql2.Append("'"+ model.CalledRuleID +"',");
}
if(model.vc_Memo!=null)
{
strSql1.Append("vc_Memo,");
strSql2.Append("'"+ model.vc_Memo +"',");
}
if(model.i_Flag!=null)
{
strSql1.Append("i_Flag,");
strSql2.Append("'"+ model.i_Flag +"',");
}
strSql.Append("insert into m_CalinglSourceRule(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
if (IsReturnID)
{
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
Result = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
else
Result=-1;
}
else
{
Result = ExecuteSql(strSql.ToString());
}
return Result;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DB_Talk.Model.m_CalinglSourceRule model,string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update m_CalinglSourceRule set ");
if(model.BoxID!=null)
{
strSql.Append("BoxID='"+ model.BoxID +"',");
}
if(model.vc_Code!=null)
{
strSql.Append("vc_Code='"+ model.vc_Code +"',");
}
if(model.vc_Name!=null)
{
strSql.Append("vc_Name='"+ model.vc_Name +"',");
}
if(model.CallingOrigID!=null)
{
strSql.Append("CallingOrigID='"+ model.CallingOrigID +"',");
}
if(model.i_ServerType!=null)
{
strSql.Append("i_ServerType='"+ model.i_ServerType +"',");
}
if(model.i_MinReLength!=null)
{
strSql.Append("i_MinReLength='"+ model.i_MinReLength +"',");
}
if(model.OriRouteID!=null)
{
strSql.Append("OriRouteID='"+ model.OriRouteID +"',");
}
if(model.CalledRuleID!=null)
{
strSql.Append("CalledRuleID='"+ model.CalledRuleID +"',");
}
if(model.vc_Memo!=null)
{
strSql.Append("vc_Memo='"+ model.vc_Memo +"',");
}
if(model.i_Flag!=null)
{
strSql.Append("i_Flag='"+ model.i_Flag +"',");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
else
strSql.Append(" where ID=" + model.ID +"");
int rows=ExecuteSql(strSql.ToString());
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DB_Talk.Model.m_FAP model)
{
return Add(model,false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DB_Talk.Model.m_FAP model)
{
return Update(model,"");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DB_Talk.Model.Data_MemberState model)
{
return Update(model,"");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DB_Talk.Model.Data_MemberState model)
{
return Add(model,false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(DB_Talk.Model.SubscriberProfile model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据,并返回ID
/// </summary>
public int Add(DB_Talk.Model.m_FAP model,bool IsReturnID)
{
return dal.Add(model,IsReturnID);
}
/// <summary>
/// 增加一条数据,并返回ID
/// </summary>
public int Add(DB_Talk.Model.m_Departments model,bool IsReturnID)
{
return dal.Add(model,IsReturnID);
}
/// <summary>
/// 根据条件更新数据
/// </summary>
public bool Update(DB_Talk.Model.m_FAP model,string strWhere)
{
return dal.Update(model,strWhere);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DB_Talk.Model.m_Departments model)
{
return Update(model,"");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DB_Talk.Model.SubscriberProfile model)
{
return dal.Update(model);
}
/// <summary>
/// 根据条件更新数据
/// </summary>
public bool Update(DB_Talk.Model.m_Departments model,string strWhere)
{
return dal.Update(model,strWhere);
}
/// <summary>
/// 增加一条数据,并返回ID
/// </summary>
public int Add(DB_Talk.Model.Data_MemberState model,bool IsReturnID)
{
return dal.Add(model,IsReturnID);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DB_Talk.Model.m_CalledRule model,string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update m_CalledRule set ");
if(model.CalledID!=null)
{
strSql.Append("CalledID='"+ model.CalledID +"',");
}
if(model.BoxID!=null)
{
strSql.Append("BoxID='"+ model.BoxID +"',");
}
if(model.vc_Code!=null)
{
strSql.Append("vc_Code='"+ model.vc_Code +"',");
}
if(model.vc_Name!=null)
{
strSql.Append("vc_Name='"+ model.vc_Name +"',");
}
if(model.CallingOriID!=null)
{
strSql.Append("CallingOriID='"+ model.CallingOriID +"',");
}
if(model.vc_CalledNumber!=null)
{
strSql.Append("vc_CalledNumber='"+ model.vc_CalledNumber +"',");
}
if(model.i_CalledType!=null)
{
strSql.Append("i_CalledType='"+ model.i_CalledType +"',");
}
if(model.i_CalledSubType!=null)
{
strSql.Append("i_CalledSubType='"+ model.i_CalledSubType +"',");
}
if(model.DestRouteID!=null)
{
strSql.Append("DestRouteID='"+ model.DestRouteID +"',");
}
if(model.i_CalledChangeType!=null)
{
strSql.Append("i_CalledChangeType='"+ model.i_CalledChangeType +"',");
}
if(model.i_CalledChangePosition!=null)
{
strSql.Append("i_CalledChangePosition='"+ model.i_CalledChangePosition +"',");
}
if(model.i_CalledChangeLength!=null)
{
strSql.Append("i_CalledChangeLength='"+ model.i_CalledChangeLength +"',");
}
if(model.vc_CalledChangeTarget!=null)
{
strSql.Append("vc_CalledChangeTarget='"+ model.vc_CalledChangeTarget +"',");
}
if(model.vc_Memo!=null)
{
strSql.Append("vc_Memo='"+ model.vc_Memo +"',");
}
if(model.i_SIPID!=null)
{
strSql.Append("i_SIPID='"+ model.i_SIPID +"',");
}
if(model.i_PRIID!=null)
{
strSql.Append("i_PRIID='"+ model.i_PRIID +"',");
}
if(model.i_Flag!=null)
{
strSql.Append("i_Flag='"+ model.i_Flag +"',");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
else
strSql.Append(" where ID=" + model.ID +"");
int rows=ExecuteSql(strSql.ToString());
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 根据条件更新数据
/// </summary>
public bool Update(DB_Talk.Model.Data_MemberState model,string strWhere)
{
return dal.Update(model,strWhere);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DB_Talk.Model.m_CalledRule model,bool IsReturnID)
{
int Result=0;
StringBuilder strSql=new StringBuilder();
StringBuilder strSql1=new StringBuilder();
StringBuilder strSql2=new StringBuilder();
if(model.CalledID!=null)
{
strSql1.Append("CalledID,");
strSql2.Append("'"+ model.CalledID +"',");
}
if(model.BoxID!=null)
{
strSql1.Append("BoxID,");
strSql2.Append("'"+ model.BoxID +"',");
}
if(model.vc_Code!=null)
{
strSql1.Append("vc_Code,");
strSql2.Append("'"+ model.vc_Code +"',");
}
if(model.vc_Name!=null)
{
strSql1.Append("vc_Name,");
strSql2.Append("'"+ model.vc_Name +"',");
}
if(model.CallingOriID!=null)
{
strSql1.Append("CallingOriID,");
strSql2.Append("'"+ model.CallingOriID +"',");
}
if(model.vc_CalledNumber!=null)
{
strSql1.Append("vc_CalledNumber,");
strSql2.Append("'"+ model.vc_CalledNumber +"',");
}
if(model.i_CalledType!=null)
{
strSql1.Append("i_CalledType,");
strSql2.Append("'"+ model.i_CalledType +"',");
}
if(model.i_CalledSubType!=null)
{
strSql1.Append("i_CalledSubType,");
strSql2.Append("'"+ model.i_CalledSubType +"',");
}
if(model.DestRouteID!=null)
{
strSql1.Append("DestRouteID,");
strSql2.Append("'"+ model.DestRouteID +"',");
}
if(model.i_CalledChangeType!=null)
{
strSql1.Append("i_CalledChangeType,");
strSql2.Append("'"+ model.i_CalledChangeType +"',");
}
if(model.i_CalledChangePosition!=null)
{
strSql1.Append("i_CalledChangePosition,");
strSql2.Append("'"+ model.i_CalledChangePosition +"',");
}
if(model.i_CalledChangeLength!=null)
{
strSql1.Append("i_CalledChangeLength,");
strSql2.Append("'"+ model.i_CalledChangeLength +"',");
}
if(model.vc_CalledChangeTarget!=null)
{
strSql1.Append("vc_CalledChangeTarget,");
strSql2.Append("'"+ model.vc_CalledChangeTarget +"',");
}
if(model.vc_Memo!=null)
{
strSql1.Append("vc_Memo,");
strSql2.Append("'"+ model.vc_Memo +"',");
}
if(model.i_SIPID!=null)
{
strSql1.Append("i_SIPID,");
strSql2.Append("'"+ model.i_SIPID +"',");
}
if(model.i_PRIID!=null)
{
strSql1.Append("i_PRIID,");
strSql2.Append("'"+ model.i_PRIID +"',");
}
if(model.i_Flag!=null)
{
strSql1.Append("i_Flag,");
strSql2.Append("'"+ model.i_Flag +"',");
}
strSql.Append("insert into m_CalledRule(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
if (IsReturnID)
{
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
Result = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
else
Result=-1;
}
else
{
Result = ExecuteSql(strSql.ToString());
}
return Result;
}