package friends.destination;
import friends.ajaj.action.AjajAction;
import friends.web.struts.ActionForward;
import javax.servlet.http.HttpServletRequest;
import friends.web.struts.ActionData;
import friends.dataset.MemoryDataSet;
import friends.dataset.MemoryDataSetProvider;
import friends.common.LoginBean;
import friends.dataset.MemoryDataSetResolver;
public class MyWorkStatusSave extends AjajAction{
public ActionForward process(ActionData actionData) throws java.lang.Exception{
actionData.getRequest().setCharacterEncoding("UTF-8");
HttpServletRequest request = actionData.getRequest();
LoginBean loginBean = LoginBean.getInstance( (HttpServletRequest) request);
String fgsid=loginBean.getFilialeId();
String personid=loginBean.getUserId();
String personname=loginBean.getUserName();
MemoryDataSetProvider pro = new MemoryDataSetProvider();
MemoryDataSetResolver res = new MemoryDataSetResolver();
String actionType=actionData.getParameter("actionType","");
try{
//我的去向 保存
if(actionType.equals("mywhereabout")){
//获取id,判断是保存数据还是插入数据
String whereaboutid=actionData.getParameter("whereaboutid","");
Boolean isnewInsert=false;
//插入数据,创建新的id
if(whereaboutid.length()==0 ){
isnewInsert=true;
whereaboutid=pro.getSequence("SELECT get_sequence('oa_whereabout') FROM dual ");
}
MemoryDataSet dsEdit=new MemoryDataSet();
dsEdit.setProvider(pro);
dsEdit.setResolver(res);
dsEdit.setReplaceQuotate(false);
dsEdit.setQueryString("select a.* from oa_whereabout a where a.fgsid='"+fgsid+"' and a.whereaboutid='"+whereaboutid+"'");
dsEdit.openDataSet();
String workstateid=actionData.getParameter("stateno","");
String statename=actionData.getParameter("statename","");
String workaddr=actionData.getParameter("workaddr","");
String workdesc=actionData.getParameter("workdesc","");
if(workstateid.length()==0){
print("{sucess:\"2\",title:\"保存失败,序号不能为空!\"}");
}
if(statename.length()==0){
print("{sucess:\"2\",title:\"保存失败,状态名称不能为空!\"}");
}
if(statename.length()>6){
print("{sucess:\"2\",title:\"保存失败,状态名称最大可输入6个汉字!\"}");
}
if(workaddr.length()!=0){
dsEdit.setValue("workaddr",workaddr);
}
if (workdesc.length() != 0) {
dsEdit.setValue("workdesc",workdesc);
}
// String workdate = pro.getSequence("SELECT DATE_FORMAT( now(), '%Y-%m-%d %H:%i:%s') scrq "); //日期
String workdate = pro.getSequence("SELECT DATE_FORMAT( now(), '%Y-%m-%d') scrq "); //日期
dsEdit.setValue("whereaboutid",whereaboutid);
dsEdit.setValue("workstateid",workstateid);
dsEdit.setValue("statename",statename);
dsEdit.setValue("workdate",workdate);
dsEdit.setValue("fgsid",fgsid);
dsEdit.setValue("workdate",workdate);
dsEdit.setValue("fgsid",fgsid);
dsEdit.setValue("personid",personid);
dsEdit.setValue("personname",personname);
dsEdit.post();
dsEdit.saveChanges();
print("{sucess:\"1\",title:\"保存成功!\",whereaboutid:\""+whereaboutid+"\"}");
}
}catch(Exception e){
print("{sucess:\"0\",title:\"保存失败!\"}");
}
return null;
}
}
Jbuilder 代码格式
最新推荐文章于 2019-06-05 00:51:02 发布