/// <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)); }
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)); }