/// <summary>
/// 检查表头
/// </summary>
/// <param name="templateID"></param>
/// <param name="title"></param>
/// <returns></returns>
public static bool CheckTitle(int templateID, List <string> title)
{
try
{
Dictionary <int, List <string> > myDic = new Dictionary <int, List <string> >();
using (TAXDBDataContext db = new TAXDBDataContext())
{
//db.Connection.ConnectionString = Cryptogram.DecryptPassword(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
var cids = db.v_TEMPLATECOLs.Where(v => v.TC_TIID == templateID).OrderBy(vt => vt.TC_ORDER).Select(a => a).ToList();
int i = 0;
foreach (var cid in cids)
{
//default
//add alis
List <string> cas = db.COLUMNS_ALIAs.Where(v => v.CA_CIID == cid.CI_ID).Select(a => a.CA_ALIAS).ToList();
string t = title[i].Replace(" ", string.Empty);
if (cas.Contains(t) == false && cid.CI_NAME != t)
{
return(false);
}
i++;
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public static TAX_RATE GetTaxRate(int taxid)
{
using (TAXDBDataContext db = new TAXDBDataContext())
{
return(db.TAX_RATEs.Where(a => a.TR_ID == taxid).SingleOrDefault());
}
}
/// <summary>
/// 获取公司国别信息
/// </summary>
/// <param name="acid"></param>
/// <returns></returns>
public static v_AgentCountry GetACInfo(int acid)
{
using (TAXDBDataContext db = new TAXDBDataContext())
{
return(db.v_AgentCountries.SingleOrDefault(a => a.AC_ID == acid));
}
}
/// <summary>
/// 模板列插入
/// </summary>
/// <param name="data"></param>
/// <param name="templateID"></param>
/// <param name="IBID"></param>
/// <returns></returns>
public static string GetInsertString(List <string> data, int templateID, int IBID)
{
string result = string.Empty;
using (TAXDBDataContext db = new TAXDBDataContext())
{
List <v_TEMPLATECOL> tcs = db.v_TEMPLATECOLs.Where(v => v.TC_TIID == templateID).OrderBy(vt => vt.TC_ORDER).Select(a => a).ToList();
string s = string.Empty;
int i = 0;
foreach (var v in tcs)
{
if (v.CI_TYPEID == 1)
{
data[i] = "'" + data[i] + "'";
}
i++;
}
string cols = String.Join(",", tcs.Select(a => a.CI_COLNAME).ToList());
string datas = string.Join(",", data);
result = string.Format("Insert into SALARY_IMPORT ({0},SI_TPID,SI_IBID) values({1},{2},{3})", cols, datas, templateID, IBID);
}
return(result);
}
public static bool IsRowCanInsert(List <string> data, int templateID)
{
//first col num should be equal;
using (TAXDBDataContext db = new TAXDBDataContext())
{
List <v_TEMPLATECOL> tcs = db.v_TEMPLATECOLs.Where(v => v.TC_TIID == templateID).OrderBy(vt => vt.TC_ORDER).Select(a => a).ToList();
if (tcs.Count != data.Count)
{
return(false);
}
try
{
int i = 0;
foreach (var tc in tcs)
{
if (tc.CI_TYPEID == 0)
{
decimal x = Convert.ToDecimal(data[i]);
i++;
}
}
}
catch (Exception e)
{
return(false);
}
return(true);
}
}
/// <summary>
/// 获取纳税人信息
/// </summary>
/// <param name="tpid"></param>
/// <returns></returns>
public static TAX_PLAYER GetTaxPlayer(int tpid)
{
using (TAXDBDataContext db = new TAXDBDataContext())
{
return(db.TAX_PLAYERs.SingleOrDefault(ai => ai.TP_ID == tpid));
}
}
/// <summary>
/// 获取公司信息
/// </summary>
/// <param name="acid"></param>
/// <returns></returns>
public static AGENT_INFO GetAgentInfo(int acid)
{
using (TAXDBDataContext db = new TAXDBDataContext())
{
return(db.AGENT_INFOs.SingleOrDefault(ai => ai.AI_ID == (db.AGENT_COUNTRies.SingleOrDefault(a => a.AC_ID == acid)).AC_AIID));
}
}
private void loadCurrency()
{
using (TAXDBDataContext db = new TAXDBDataContext())
{
dgvCurrency.DataSource = db.v_CURRENCies.Select(a => a);
}
}
public void LoadData()
{
using (TAXDBDataContext db = new TAXDBDataContext())
{
//db.Connection.ConnectionString = Cryptogram.DecryptPassword(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
cbxAgents.Items.Clear();
var data = db.AGENT_INFOs.Where(a => a.AI_ISDEL == false).Select(p => p);
cbxAgents.DataSource = data;
}
}
/// <summary>
/// 加载年度
/// </summary>
private void loadYears()
{
dgvYear.Rows.Clear();
using (TAXDBDataContext db = new TAXDBDataContext())
{
var data = db.v_AgentYears.Select(a => a);
foreach (var d in data)
{
dgvYear.Rows.Add(d.AY_ID, d.AY_NAME.ToString(), d.AY_ISCURRENT, d.UI_NAME, d.AY_ADDTIME);
}
}
}
/// <summary>
/// 获取纳税人ID
/// </summary>
/// <param name="ACID"></param>
/// <param name="playerName"></param>
/// <returns></returns>
internal static int GetPlayerID(int ACID, string playerName)
{
using (TAXDBDataContext db = new TAXDBDataContext())
{
//db.Connection.ConnectionString = Cryptogram.DecryptPassword(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
var ay = db.TAX_PLAYERs.SingleOrDefault(v => v.TP_ACID == ACID && v.TP_NAME == playerName);
if (ay != null)
{
return(ay.TP_ID);
}
return(-1);
}
}
/// <summary>
/// 获取当前年度
/// </summary>
/// <returns></returns>
public static int GetCurrentYear()
{
int result = 0;
using (TAXDBDataContext db = new TAXDBDataContext())
{
AGENT_YEAR ay = db.AGENT_YEARs.SingleOrDefault(v => v.AY_ISCURRENT == true);
if (ay != null)
{
result = ay.AY_NAME;
}
return(result);
}
}
/// <summary>
/// 获取税率等级
/// </summary>
/// <param name="p"></param>
/// <param name="minus"></param>
/// <param name="isBonus"></param>
/// <returns></returns>
public static TAX_RATE GetTaxRate(decimal p, decimal minus, bool isBonus = false)
{
decimal tmp = p;
if (!isBonus)
{
tmp = tmp - minus;
}
using (TAXDBDataContext db = new TAXDBDataContext())
{
return(db.TAX_RATEs.Where(a => tmp > a.TR_LOW && tmp <= a.TR_HIGH).SingleOrDefault());
}
}
/// <summary>
/// 查询公司国别ID
/// </summary>
/// <param name="agentName"></param>
/// <param name="agentCName"></param>
/// <returns></returns>
public static int GetAgentCID(string agentName, string agentCName)
{
int result = -1;
using (TAXDBDataContext db = new TAXDBDataContext())
{
var ay = db.v_AgentCountries.SingleOrDefault(v => v.AI_NAME == agentName && v.AC_NAME == agentCName);
if (ay != null)
{
result = ay.AC_ID;
}
return(result);
}
}
/// <summary>
/// 查询公司ID
/// </summary>
/// <param name="agentName"></param>
/// <returns></returns>
public static int GetAgentID(string agentName)
{
int result = -1;
using (TAXDBDataContext db = new TAXDBDataContext())
{
AGENT_INFO ay = db.AGENT_INFOs.SingleOrDefault(v => v.AI_NAME == agentName);
if (ay != null)
{
result = ay.AI_ID;
}
return(result);
}
}
private void cbxAgents_SelectedIndexChanged(object sender, EventArgs e)
{
using (TAXDBDataContext db = new TAXDBDataContext())
{
//db.Connection.ConnectionString = Cryptogram.DecryptPassword(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
cbxAgentCs.Items.Clear();
var data = db.AGENT_COUNTRies.Where(a => a.AC_AIID == ((AGENT_INFO)cbxAgents.SelectedItem).AI_ID).Select(p => p);
foreach (var d in data)
{
cbxAgentCs.Items.Add(d);
}
}
}
/// <summary>
/// 获取默认减费用
/// </summary>
/// <returns></returns>
internal static decimal GetMinus()
{
if (minus != 0)
{
return(minus);
}
using (TAXDBDataContext db = new TAXDBDataContext())
{
//db.Connection.ConnectionString = Cryptogram.DecryptPassword(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
var ay = db.OPTIONs.SingleOrDefault(v => v.O_KEY == "MINUS");
if (ay != null)
{
minus = Convert.ToDecimal(ay.O_VALUE);
}
return(minus);
}
}
/// <summary>
/// 新增年度
/// </summary>
private void addYear()
{
if (!checkInput())
{
MessageBox.Show("请检查输入项", this.funName);
return;
}
using (TAXDBDataContext db = new TAXDBDataContext())
{
AGENT_YEAR ay = new AGENT_YEAR
{
AY_NAME = Convert.ToInt32(txtYear.Text.Trim()),
AY_ADDTIME = DateTime.Now,
AY_UIID = SysUtil.CurrentUserID(),
};
db.AGENT_YEARs.InsertOnSubmit(ay);
db.SubmitChanges();
loadYears();
}
}
/// <summary>
/// 增加货币单位
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddCurr_Click(object sender, EventArgs e)
{
if (!checkInputOfCurrency())
{
MessageBox.Show("请检查输入项");
return;
}
using (TAXDBDataContext db = new TAXDBDataContext())
{
//db.Connection.ConnectionString = Cryptogram.DecryptPassword(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
CURRENCY curr = new CURRENCY
{
C_ADDTIME = DateTime.Now,
C_NAME = txtCurrency.Text.Trim(),
C_UIID = SysUtil.CurrentUserID(),
C_ISDEL = false
};
db.CURRENCies.InsertOnSubmit(curr);
db.SubmitChanges();
loadCurrency();
MessageBox.Show("添加成功");
}
}
/// <summary>
/// 设置为当前年度
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SetcurrentYear(object sender, EventArgs e)
{
if (dgvYear.SelectedRows.Count != 1)
{
MessageBox.Show("请选择一行后进行操作", this.funName);
return;
}
using (TAXDBDataContext db = new TAXDBDataContext())
{
AGENT_YEAR old = db.AGENT_YEARs.SingleOrDefault(a => a.AY_ISCURRENT == true);
if (old != null)
{
old.AY_ISCURRENT = false;
}
db.SubmitChanges();
AGENT_YEAR ay = db.AGENT_YEARs.SingleOrDefault(a => a.AY_ID == (int)dgvYear.SelectedRows[0].Cells[0].Value);
ay.AY_ISCURRENT = true;
db.SubmitChanges();
loadYears();
MessageBox.Show("修改成功", this.funName);
}
}
