Exemple #1
0
        /// <summary>
        /// 添加电话
        /// </summary>
        /// <param name="p"></param>
        /// <returns></returns>
        public int PhoneExtensionRequest(PhoneExtensionRequest p)
        {
            string sql = @"insert into c_application_phoneextension(OBJECTID,APPLICATIONNUMBER,MIANAPPLICANTNAME,CALLEDPARTYNAME,CALLEDPARTYTYPE,CALLEDPARTYNUMBER,CALLEDPARTYNUMBERTYPE,CREATEDTIME,STATUS)
                         values('" + p.ObjectId + "','" + p.Applicationnumber + "','" + p.Mianapplicantname + "','" + p.Calledpartyname + "','" + p.Calledpartytype + "','" + p.Calledpartynumber + "','" + p.Calledpartynumbertype + "',to_date('" + p.Createdtime + "','yyyy/mm/dd HH24:MI:SS'),'" + p.Status + "')";

            return(OThinker.H3.Controllers.AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteNonQuery(sql));
        }
Exemple #2
0
        public JsonResult CallCenterInsert(PhoneExtensionRequest p)
        {
            p.Status      = 1;
            p.ObjectId    = Guid.NewGuid().ToString();
            p.Createdtime = DateTime.Now.ToString();

            rtn_data rtn = new rtn_data {
                code = 1
            };
            var officePhone = PhoneExtensionRequest(p);

            rtn.data = officePhone;
            return(Json(rtn, JsonRequestBehavior.AllowGet));
        }