public ActionResult ImportToTAX(string zmInfo)
{
ZMInfo resMode = null;
try
{
byte[] data_byte = Encoding.UTF8.GetBytes(zmInfo);
string date = Encoding.UTF8.GetString(data_byte, 0, data_byte.Length);
if (!string.IsNullOrEmpty(date))
{
resMode = Newtonsoft.Json.JsonConvert.DeserializeObject <ZMInfo>(date);
TAXModels model = CreateModel(resMode);
TAXDAL dal = new TAXDAL();
dal.Insert(model);
InsertLog(resMode, date, "成功", true);
}
}
catch (Exception ex)
{
InsertLog(resMode, zmInfo, ex.Message, false);
return(Json(ex.Message));
}
return(null);
}
private TAXModels CreateModel(ZMInfo zmModel)
{
TAXModels model = new TAXModels();
if (null == model.proofInfo)
{
model.proofInfo = new proofinfo();
}
model.proofInfo.经办日期 = DateTime.Now;
model.proofInfo.利用单位 = "税务";
model.proofInfo.申请编号 = zmModel.SQBH;
model.proofInfo.申请人 = zmModel.SQRInfo.XM;
model.proofInfo.申请人证件号码 = zmModel.SQRInfo.ZJH;
model.proofInfo.申请人证件类型 = "身份证";
model.proofInfo.申请时间 = DateTime.Now;
model.proofInfo.备注 = zmModel.BZ;
model.personList = CreatePerson(zmModel);
model.zfxxList = CreateZFXX(zmModel, model.personList);
return(model);
}
public void Insert(TAXModels models)
{
dbHelper.CreateConn();
if (dbHelper.Conn.State != System.Data.ConnectionState.Open)
{
dbHelper.Conn.Open();
}
DbTransaction trs = dbHelper.Conn.BeginTransaction();
try
{
InsertProofInfo(models.proofInfo, trs);
InsertProofperson(models.personList, trs);
InsertZFXX(models.zfxxList, trs);
trs.Commit();
}
catch (Exception ex)
{
string str = ex.Message;
trs.Rollback();
}
}
