private void DataSearch()
{
DataTable dtData = DbHelperOra.Query(GetSearchSql()).Tables[0];
GridCom.DataSource = dtData;
GridCom.DataBind();
OutputSummaryData(dtData);
}
public void GenerateEnemies(int startX, int startY, int endX, int endY, GridCom grid, int difficulty, List <UnitType> accessibleUnits, Faction faction, long seed)
{
Debug.Assert(startX < endX);
Debug.Assert(startY < endY);
var cells = grid.Cells;
var unitsToCreate = new Stack <UnitType>();
var nextSeed = seed;
while (difficulty > 0)
{
nextSeed = Utility.Randomlong(nextSeed);
var nextUnitType = Utility.RandomElement(accessibleUnits, nextSeed);
var tempDifficulty = difficulty - UnitInfoCom.DifficultyRatingForType(nextUnitType);
if (tempDifficulty >= 0)
{
unitsToCreate.Push(nextUnitType);
difficulty = tempDifficulty;
}
else
{
accessibleUnits.RemoveAll(i =>
UnitInfoCom.DifficultyRatingForType(i) >= UnitInfoCom.DifficultyRatingForType(nextUnitType)
);
if (accessibleUnits.Count <= 0)
{
break;
}
}
}
var xSeed = (seed + ((startX * 576976759) + (endX * 104589539))) % 1828081061;
int x = Utility.RandomInt(startX, endX, xSeed);
var ySeed = (seed + ((startY * 2755125551) + (endY * 1920502651))) % 5291225924533335701;
int y = Utility.RandomInt(startY, endY, ySeed);
while (unitsToCreate.Count > 0)
{
if (cells[y, x].SpaceAvailable)
{
var nextUnit = unitsToCreate.Pop();
EntFactory.Instance.CreateFootSolider(grid, y, x, faction, nextUnit);
}
xSeed = Utility.Randomlong(xSeed);
x = Utility.RandomInt(startX, endX, xSeed);
ySeed = Utility.Randomlong(ySeed);
y = Utility.RandomInt(startY, endY, ySeed);
}
}
protected void GridCom_Sort(object sender, GridSortEventArgs e)
{
GridCom.SortDirection = e.SortDirection;
GridCom.SortField = e.SortField;
DataTable table = PubFunc.GridDataGet(GridCom);
DataView view1 = table.DefaultView;
view1.Sort = String.Format("{0} {1}", GridCom.SortField, GridCom.SortDirection);
GridCom.DataSource = view1;
GridCom.DataBind();
}
public void Genrate(int chunksX, int chunksY, GridCom gridCom, long seed)
{
var visited = new HashSet <Vector2i>();
var chunkSeeds = new HashSet <long>();
for (int i = 0; i < chunksY; i++)
{
for (int j = 0; j < chunksX; j++)
{
var chunkSeed = seed - (((j * 1081377109) + (i * 2149545691)) % 1656974148464943);
Debug.Assert(!chunkSeeds.Contains(chunkSeed));
chunkSeeds.Add(chunkSeed);
Biomes.RandomValue(chunkSeed).
GenrateChunk(
i * GameConstants.CHUNK_SIZE,
j * GameConstants.CHUNK_SIZE,
gridCom.Cells,
visited,
chunkSeed
);
}
}
// Clean unassignedCells
foreach (var cell in gridCom.Cells)
{
if (cell.Type == CellInfoCom.CellType.Nothing)
{
var adjacent = Utility.GetAdjacentSquares(cell.Cords.X, cell.Cords.Y, gridCom.Cells)
.Where(i => gridCom.Cells[i.X, i.Y].Type != CellInfoCom.CellType.Nothing);
var nextSeed = seed - cell.Cords.X + cell.Cords.Y * 4112019;
CellInfoCom.CellType newType = CellInfoCom.CellType.Grass;
if (adjacent.Count() > 0)
{
var cellToCopyIndex = Utility.RandomElement(adjacent, nextSeed);
newType = gridCom.Cells[cellToCopyIndex.X, cellToCopyIndex.Y].Type;
}
cell.Type = newType;
}
cell.ClearNotNeededChildren();
}
}
/* 直接取出供应商评价详情信息（备用）
* protected void GridGoods_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
* {
* //string supCode = GridGoods.Rows[e.RowIndex].DataKeys[0].ToString();
* //PageContext.RegisterStartupScript("top._nav.myMenu('add',{id:'" + CurrScene + "',title:'供应商评价详情',url:'/UI/Windows/SupEvaluationDetail.aspx?supCode=" + supCode + "&scene=" + CurrScene + "',close:true});");
* string billNo = GridGoods.Rows[GridGoods.SelectedRowIndex].DataKeys[0].ToString();
* string PSSID = GridGoods.Rows[GridGoods.SelectedRowIndex].DataKeys[1].ToString();
* string PSSNAME = GridGoods.Rows[GridGoods.SelectedRowIndex].DataKeys[2].ToString();
* Window2.Hidden = false;
* Window2.IFrameUrl = "../ERPStorage/SupEvaluation.aspx?billno=" + billNo + "&PSSID=" + PSSID + "&PSSNAME=" + PSSNAME;
* }*/
protected void billOpen(string strBillno)
{
DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0];
if (dtDoc != null && dtDoc.Rows.Count > 0)
{
PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]);
}
else
{
Alert.Show("单据信息获取失败！！！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (docLRY.SelectedValue == null)
{
docLRY.SelectedValue = UserAction.UserID;
}
PageContext.RegisterStartupScript(GridCom.GetRejectChangesReference());
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0];
if (dtBill != null && dtBill.Rows.Count > 0)
{
decimal ddslTotal = 0, bzslTotal = 0, feeTotal = 0;
foreach (DataRow row in dtBill.Rows)
{
ddslTotal += Convert.ToDecimal(string.IsNullOrWhiteSpace(row["DDSL"].ToString()) ? "0" : row["DDSL"].ToString());
if (!PubFunc.StrIsEmpty(Convert.ToString(row["BZSL"] ?? "0")))
{
bzslTotal += Convert.ToDecimal(row["BZSL"] ?? "0");
// 还要乘以最小单位
//feeTotal += Convert.ToDecimal(Convert.ToString(row["HSJJ"])) * Convert.ToDecimal(Convert.ToString(row["BZSL"] ?? "0")) * Convert.ToDecimal(Convert.ToString(row["SSSL"] ?? "0"));
feeTotal += Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZSL"] ?? "0");
}
row["HSJE"] = Convert.ToDecimal(row["HSJE"]).ToString("F2");
}
Doc.GridRowAdd(GridCom, dtBill);
//计算合计数量
JObject summary = new JObject();
summary.Add("GDNAME", "本页合计");
summary.Add("DDSL", ddslTotal.ToString());
summary.Add("BZSL", bzslTotal.ToString());
summary.Add("HSJE", feeTotal.ToString("F2"));
GridCom.SummaryData = summary;
}
}
private void DataSearch2()
{
string sql = "";
if (DbHelperOra.Exists("SELECT 1 FROM SYS_PARA WHERE CODE = 'ShowName' AND VALUE = 'HIS'"))
{
sql = @"SELECT SP.GDSEQ,SP.GDID,SP.BARCODE,SP.ZJM,SP.YCODE,SP.NAMEJC,SP.NAMEEN,SP.GDMODE,SP.STRUCT,SP.BZHL,SP.UNIT,SP.FLAG,SP.CATID,SP.JX,SP.YX,SP.PIZNO,SP.BAR1,SP.BAR2,SP.BAR3,SP.DEPTID,SP.SUPPLIER,SP.LOGINLABEL,SP.PRODUCER,SP.ZPBH,SP.PPID,SP.CDID,SP.JXTAX,SP.XXTAX,SP.BHSJJ,SP.HSJJ,SP.LSJ,SP.YBJ,SP.HSID,SP.HSJ,SP.JHZQ,SP.ZDKC,SP.HLKC,SP.ZGKC,SP.SPZT,SP.DAYXS,SP.MANAGER,SP.INPER,SP.INRQ,SP.BEGRQ,SP.ENDRQ,SP.UPTRQ,SP.UPTUSER,SP.MEMO,DISABLEORG,SP.ISLOT,SP.ISJB,SP.ISFZ,SP.ISGZ,SP.ISIN,SP.ISJG,SP.ISDM,SP.ISCF,SP.ISYNZJ,SP.ISFLAG1,nvl(SP.STR3,SP.GDSPEC) GDSPEC,SP.UNIT_DABZ,SP.UNIT_ZHONGBZ,SP.BARCODE_DABZ,SP.NUM_DABZ,SP.NUM_ZHONGBZ,SP.UNIT_ORDER,SP.UNIT_SELL,SP.HISCODE,nvl(SP.HISNAME,SP.GDNAME) GDNAME,SP.CATID0,
F_GETUNITNAME(UNIT) UNITNAME,SP.PRODUCER,F_GETPRODUCERNAME(SP.PRODUCER) PRODUCERNAME,F_GETSUPNAME(SUPPLIER) SUPPLIERNAME,(nvl(PZ.DSNUM,0) - nvl(PZ.NUM3,0)- nvl(PZ.DSPOOL,0)) sum_num,PZ.DSNUM,nvl(PZ.NUM1,0) NUM_XS,nvl(PZ.NUM3,0) NUM_DS,
F_GETUNITNAME(UNIT_ORDER) UNIT_ORDER_NAME,F_GETUNITNAME(UNIT_SELL) UNIT_SELL_NAME,F_GETUNITNAME(UNIT_DABZ) UNIT_DABZ_NAME,NVL(PZ.ISJF,'Y') ISJF,
F_GETUNITNAME(UNIT_ZHONGBZ) UNIT_ZHONGBZ_NAME,f_gethwid('{1}',SP.GDSEQ) HWID,NVL((SELECT wmsys.wm_concat(gdseq) FROM VIEW_DS WHERE GDSEQ_OLD = SP.GDSEQ AND DEPTID = '{0}'),'不存在') DT";
}
else
{
sql = @"SELECT SP.GDSEQ,SP.GDID,SP.BARCODE,SP.ZJM,SP.YCODE,SP.NAMEJC,SP.NAMEEN,SP.GDMODE,SP.STRUCT,SP.BZHL,SP.UNIT,SP.FLAG,SP.CATID,SP.JX,SP.YX,SP.PIZNO,SP.BAR1,SP.BAR2,SP.BAR3,SP.DEPTID,SP.SUPPLIER,SP.LOGINLABEL,SP.PRODUCER,SP.ZPBH,SP.PPID,SP.CDID,SP.JXTAX,SP.XXTAX,SP.BHSJJ,SP.HSJJ,SP.LSJ,SP.YBJ,SP.HSID,SP.HSJ,SP.JHZQ,SP.ZDKC,SP.HLKC,SP.ZGKC,SP.SPZT,SP.DAYXS,SP.MANAGER,SP.INPER,SP.INRQ,SP.BEGRQ,SP.ENDRQ,SP.UPTRQ,SP.UPTUSER,SP.MEMO,DISABLEORG,SP.ISLOT,SP.ISJB,SP.ISFZ,SP.ISGZ,SP.ISIN,SP.ISJG,SP.ISDM,SP.ISCF,SP.ISYNZJ,SP.ISFLAG1,nvl(SP.STR3,SP.GDSPEC) GDSPEC,SP.UNIT_DABZ,SP.UNIT_ZHONGBZ,SP.BARCODE_DABZ,SP.NUM_DABZ,SP.NUM_ZHONGBZ,SP.UNIT_ORDER,SP.UNIT_SELL,SP.HISCODE,SP.GDNAME,SP.CATID0,
F_GETUNITNAME(UNIT) UNITNAME,SP.PRODUCER,F_GETPRODUCERNAME(SP.PRODUCER) PRODUCERNAME,F_GETSUPNAME(SUPPLIER) SUPPLIERNAME,(nvl(PZ.DSNUM,0) - nvl(PZ.NUM3,0)- nvl(PZ.DSPOOL,0)) sum_num,PZ.DSNUM,nvl(PZ.NUM1,0) NUM_XS,nvl(PZ.NUM3,0) NUM_DS,
F_GETUNITNAME(UNIT_ORDER) UNIT_ORDER_NAME,F_GETUNITNAME(UNIT_SELL) UNIT_SELL_NAME,F_GETUNITNAME(UNIT_DABZ) UNIT_DABZ_NAME,NVL(PZ.ISJF,'Y') ISJF,
F_GETUNITNAME(UNIT_ZHONGBZ) UNIT_ZHONGBZ_NAME,f_gethwid('{1}',SP.GDSEQ) HWID,NVL((SELECT wmsys.wm_concat(gdseq) FROM VIEW_DS WHERE GDSEQ_OLD = SP.GDSEQ AND DEPTID = '{1}'),'不存在') DT";
}
StringBuilder strSql = new StringBuilder(string.Format(sql, docDEPTID.SelectedValue, docDEPTOUT.SelectedValue));
if (!string.IsNullOrWhiteSpace(docDEPTOUT.SelectedValue))
{
strSql.AppendFormat(" ,(select nvl(sum(KCSL -LOCKSL),0) from DAT_GOODSSTOCK a where a.gdseq = SP.GDSEQ and a.deptid = '{0}') KCSL,floor((select nvl(sum(KCSL - LOCKSL),0) from DAT_GOODSSTOCK a where a.gdseq = SP.GDSEQ and a.deptid = '{0}')/PZ.NUM1) SL", docDEPTOUT.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(docDEPTID.SelectedValue))
{
strSql.AppendFormat(" from DOC_GOODS SP,DOC_GOODSCFG PZ WHERE SP.FLAG IN('Y','T') AND ISDELETE='N' AND SP.GDSEQ=PZ.GDSEQ AND PZ.DSNUM > 0 AND nvl(PZ.NUM3,0) + nvl(PZ.DSPOOL,0) <= nvl(PZ.DSNUM,0) and nvl(PZ.NUM1,0) > 0 AND PZ.DEPTID='{0}' AND PZ.ISCFG IN ('1','Y') and (nvl(PZ.DSNUM, 0) - nvl(PZ.NUM3, 0) - nvl(PZ.DSPOOL, 0))>0 AND EXISTS(SELECT 1 FROM DOC_GOODSSUP GS WHERE GS.GDSEQ=SP.GDSEQ AND GS.SUPID IS NOT NULL) ", docDEPTID.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(docDEPTOUT.SelectedValue))
{
strSql.AppendFormat(" AND EXISTS(SELECT 1 FROM DOC_GOODSCFG PZ WHERE PZ.GDSEQ=SP.GDSEQ AND PZ.DEPTID ='{0}') ", docDEPTOUT.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(trbSearch.Text))
{
strSql.AppendFormat(" AND (SP.GDSEQ LIKE '%{0}%' OR SP.GDNAME LIKE '%{0}%' OR SP.ZJM LIKE '%{0}%' OR SP.BARCODE LIKE '%{0}%')", trbSearch.Text.Trim().ToUpper());
}
strSql.Append(" ORDER BY SP.GDNAME,KCSL");
GridCom.DataSource = DbHelperOra.Query(strSql.ToString()).Tables[0];
GridCom.DataBind();
}
protected void btnSearch1_Click(object sender, EventArgs e)
{
if (dpkBegRQ.SelectedDate == null || dpkEndRQ.SelectedDate == null)
{
Alert.Show("请输入条件【查询期间】！");
return;
}
else if (dpkBegRQ.SelectedDate > dpkEndRQ.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
if (docDHLX1.SelectedValue.Length < 1)
{
Alert.Show("请选择转商品类型！", MessageBoxIcon.Warning);
return;
}
DataTable dtData = DbHelperOra.Query(GetSearchSql1()).Tables[0];
OutputSummaryData1(dtData);
GridCom.DataSource = dtData;
GridCom.DataBind();
}
private void GoodsSearch()
{
string strSql = @"SELECT A.*,
NVL(B.HISNAME,B.GDNAME) HISNAME,
F_GETUNITNAME(A.UNIT) UNITNAME,
F_GETBILLFLAG(A.FLAG) FLAG_CN,
F_GETDEPTNAME(A.DEPTID) DEPTNAME,
F_GETDEPTNAME(A.DEPTOUT) DEPTOUTNAME,
F_GETSUPNAME(F_GETSHSID(a.gdseq)) PSSNAME,
F_GETUSERNAME(A.OPERUSER) OPERUSER_CN,
DECODE(B.ISFLAG3 ,'Y','true','false') ISFLAG3,
DECODE(B.ISFLAG7 ,'Y','true','false') ISFLAG7,
A.MEMO QHMEMO,
DECODE(B.ISGZ,'Y','true','false') ISGZ,F_GETCATID0NAME(B.CATID0) CATID0NAME,CATID0,
F_GETUNITNAME(DECODE(B.UNIT_SELL,'X',B.UNIT,'Z',B.UNIT_ZHONGBZ,'D',B.UNIT_DABZ))BZUNITNAME,
ROUND(A.SLSL/DECODE(B.UNIT_SELL,'X',B.BZHL,'Z',B.NUM_ZHONGBZ,'D',B.NUM_DABZ),2)BZSLSL,
ROUND(A.QHSL/DECODE(B.UNIT_SELL,'X',B.BZHL,'Z',B.NUM_ZHONGBZ,'D',B.NUM_DABZ),2)BZQHSL
FROM DAT_NOSTOCK_LIST A, DOC_GOODS B
WHERE A.GDSEQ = B.GDSEQ(+) AND A.FLAG = 'N' AND B.FLAG IN('Y','T') ";
string strSearch = "";
if (!string.IsNullOrWhiteSpace(docISGZ.SelectedValue))
{
strSearch += string.Format(" AND B.ISGZ = '{0}'", docISGZ.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(docISFLAG3.SelectedValue))
{
strSearch += string.Format(" AND B.ISFLAG3 = '{0}'", docISFLAG3.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(docCatid.SelectedValue))
{
strSearch += string.Format(" AND B.CATID0 = '{0}'", docCatid.SelectedValue);
}
if (ddlISFLAG7.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND B.ISFLAG7 = '{0}'", ddlISFLAG7.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(docBILLNO.Text.Trim()))
{
strSearch += string.Format(" AND A.BILLNO_SL LIKE '%{0}%'", docBILLNO.Text);
}
if (!string.IsNullOrWhiteSpace(docSearch.Text.Trim()))
{
strSearch += string.Format(" AND (A.GDSEQ LIKE '%{0}%' OR A.GDNAME LIKE '%{0}%')", docSearch.Text.Trim());
}
if (docSUPID.SelectedItem != null && docSUPID.SelectedItem.Value.Length > 0)
{
// strSearch += string.Format(" AND F_GETSHSID(a.gdseq)='{0}'", docSUPID.SelectedItem.Value);
strSearch += string.Format(" AND A.PSSID='{0}'", docSUPID.SelectedItem.Value);
}
if (docDEPTID.SelectedItem != null && docDEPTID.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.DEPTID='{0}'", docDEPTID.SelectedItem.Value);
}
if (ddlDEPTOUT.SelectedItem != null && ddlDEPTOUT.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.DEPTOUT='{0}'", ddlDEPTOUT.SelectedItem.Value);
}
if (docDATE_SL1.Text.Length > 0)
{
strSearch += string.Format(" AND A.DATE_SL>=TO_DATE('{0}','YYYY-MM-DD')", docDATE_SL1.Text);
}
if (docDATE_SL2.Text.Length > 0)
{
strSearch += string.Format(" AND A.DATE_SL <TO_DATE('{0}','YYYY-MM-DD') + 1", docDATE_SL2.Text);
}
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY A.BILLNO_SL DESC";
int total = 0;
DataTable dtBill = PubFunc.DbGetPage(GridCom.PageIndex, GridCom.PageSize, strSql, ref total);
GridCom.DataSource = dtBill;
GridCom.RecordCount = total;
GridCom.DataBind();
decimal bzslTotal = 0, feeTotal = 0;
if (dtBill != null && dtBill.Rows.Count > 0)
{
foreach (DataRow row in dtBill.Rows)
{
bzslTotal += Convert.ToDecimal(row["BZSL"]);
feeTotal += Convert.ToDecimal(row["QHSL"]);
}
}
//if (Request.QueryString["tp"] != null && Request.QueryString["tp"].ToString().Trim().Length > 0)
//{
// ddlDEPTOUT.SelectedValue = DbHelperOra.GetSingle("SELECT T.STR2 FROM DOC_GOODSTYPE T WHERE T.CODE=" + Request.QueryString["tp"].ToString()).ToString();
//}
//else
//{
// ddlDEPTOUT.SelectedValue = DbHelperOra.GetSingle("SELECT T.STR2 FROM DOC_GOODSTYPE T WHERE T.CODE='2'").ToString();
//}
//计算合计数量
JObject summary = new JObject();
summary.Add("PSSID", "本页合计");
summary.Add("BZSL", bzslTotal.ToString());
summary.Add("QHSL", feeTotal.ToString("F2"));
GridCom.SummaryData = summary;
}
public void GenerateEnemies(int startX, int startY, int endX, int endY, GridCom grid, int difficulty, Faction faction, long seed)
{
GenerateEnemies(startX, startY, endX, endY, grid, difficulty, Enum.GetValues(typeof(UnitType)).Cast <UnitType>().ToList(), faction, seed);
}
